Re: can't get user authentication to work - HELP!

Floyd Shackelford writes:

> i created a user using createuser named "user1" with password "password1"
> my pg_hba.conf file has the following entry:
> host all  192.168.1.0   255.255.255.0  password pg_passwd

> i try the following:
> psql -h 192.168.1.200 -d a_database -U user1 -W
> and i enter "password1" (sans quotes) at the password prompt and get:
> psql: FATAL 1:  SetUserId: user 'user1' is not in 'pg_shadow'
>
> How do I get this to work? How do i get an entry into pg_shadow?

Normally you get one with createuser.  Perhaps you have two different
postmasters running and the createuser command picked the wrong one?

> psql -h 192.168.1.200 -d a_database -U postgres -W
> and I get:
> psql: Password authentication failed for user 'postgres'

By default the postgres user doesn't have a password.  You need to give it
one first. (See ALTER USER.)

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/