Description of problem: When starting to try to configure a new postgresql from scratch i noticed that the createuser program didn't work when runned from the postgres user. After some further investigation it seems like postgres no longer recognizes the line local all ident sameuser in /var/lib/pgsql/data/pg_hba.conf. After starting the server manually with '/usr/bin/pg_ctl start' as user 'postgres' i got the following message when trying to connect to template1 as user user postgres: parse_hba: invalid syntax in pg_hba.conf file at line 100, token "sameuser" as a checkpoint I added local all all trust to pg_hba.conf, reloaded the configuration and I could then connect to the database from localhost. (not surprising) Version-Release number of selected component (if applicable): postgresql-server-7.3-6 How reproducible: always, at least on my system Steps to Reproduce: 1. install and start postgresql-server 2. su to user postgres 3. try to use command 'createuser' Actual results: The program fails with the following error: psql: FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for details createuser: creation of user "noa" failed Expected results: Successfullness :) Additional info: note the buglet in parse_hba, there are not 100 lines in the file in question, but rather about 50. Also, getting the error message from postgres was a little tricky. Perhaps redirecting pg_ctl output to /var/log/pgsql would be a good idea
This problem still persists in postgresql-server-7.3.1-4 from rawhide
Happens to me aswell (pretty unsurprising). Bit of a PITA ... can't see any mention of changes in the postgresql docs :( Can the priority be raised on this? It basically stops you being able to use postgres "out of the box", and even if following the instructions, as far as I can see.
Trying to raise the prio :)
This problem is fixed in the latest 7.3.2-2 packages.