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

"Floyd Shackelford" <floyds(at)4peakstech(dot)com> writes:
> my pg_hba.conf file has the following entry:
> host all 192.168.1.0 255.255.255.0 password pg_passwd

You probably just want

host all 192.168.1.0 255.255.255.0 password

What you have specifies an "alternate password file" named pg_passwd.
It's unlikely you need an alternate file.

The above might account for the failure to connect as superuser;
most likely the pg_passwd file hasn't got an entry for the superuser
(if the file even exists at all). Another possibility is that you
didn't set a password for the superuser.

Not sure why you're getting the other message
> psql: FATAL 1: SetUserId: user 'user1' is not in 'pg_shadow'
createuser should've handled that for you. What is in pg_shadow
anyway? (do a "select * from pg_shadow" as superuser to find out)

regards, tom lane