Re: Cannot create users

----- Original Message -----
> [postgres(at)salmo rshepard]$ createuser rshepard
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> psql: Missing or erroneous pg_hba.conf file, see postmaster log for
details
> createuser: creation of user "rshepard" failed
>
> Will someone please explain to me what I missed during the installation?
I
> know it must be something simple, but I don't see the answer in the
> administrator's manual. (If the answer is there, please pass me a pointer
to
> the page number and I'll go read it for myself.)

pg_hba.conf is postgres' host access file (bit like /etc/hosts.allow).
You'll probably find it somewhere under your main pgsql directory or /etc
(on this machine it is in /usr/local/pgsql/data). It lists which hosts can
connect to the database backend, so it could well be that the host you are
using is not listed there (the file contains instructions).

If you cannot find the file, get a copy from the source tar (and drop the
rpm maintainer a note to let them know there's a problem).

- Richard Huxton