postgresql instructions break automatic maintenance

[Jasper Knockaert]

The guide instructs to set a password for the postgres user, and to subsequently set the authentication method for that user to md5 in pg_hba.conf. Doing so breaks support for maintenance scripts which need access with the peer authentication method, as clearly stated in pg_hba.conf.

With the postgres user being the administrative login through the peer method, the guide should advise either to use "sudo -u postgres psql" at all times, or to create a database superuser with a different name and set a password for that user.

The guide should advise regardless to set authentication to md5 for all other connections. The default is now peer authentication for all socket connections.