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