can't get user authentication to work - HELP! - Mailing list pgsql-general

From Floyd Shackelford
Subject can't get user authentication to work - HELP!
Date
Msg-id 000b01c05018$4105a4e0$9701a8c0@fwshackelford.com
Whole thread Raw
Responses Re: can't get user authentication to work - HELP!  (Peter Eisentraut <peter_e@gmx.net>)
Re: can't get user authentication to work - HELP!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I just can't seem to figure out how to get the userid/password thing to
work.

i created a database called a_database.

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?

I even tried it with the postgres super user:

psql -h 192.168.1.200 -d a_database -U postgres -W

and I get:

psql: Password authentication failed for user 'postgres'

What do I do to get user authentication to work?

Regards,
Floyd Shackelford
4 Peaks Technology Group, Inc., http://www.4peakstech.com/
dba Corona Professional Services, http://www.coronaps.com/
P. O. Box 27740, Las Vegas, Nevada  89126
office: +1.888.398.4405  fax: +1.916.404.7125
net2phone nickname: fwshack  PGPfone: enabled

"[A]ll men are ... endowed by their Creator with certain unalienable Rights
... whenever ... Government becomes destructive of these Ends, it is the
Right of the People ... it is their Duty, to throw off such
Government...." --Declaration of Independence


pgsql-general by date:

Previous
From: Max Fonin
Date:
Subject: Enum type emulation: problem with opaque type in PL/pgSQL functions
Next
From: Tom Lane
Date:
Subject: Re: Transaction, Rollback and Database Corruption question,