postgresql instructions break automatic maintenance
Bug #1315943 reported by
Jasper Knockaert
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ubuntu Server Guide |
New
|
Undecided
|
Unassigned |
Bug Description
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.
To post a comment you must log in.