can't get user authentication to work - HELP!

Поиск
Список
Период
Сортировка
От Floyd Shackelford
Тема can't get user authentication to work - HELP!
Дата
Msg-id 000b01c05018$4105a4e0$9701a8c0@fwshackelford.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Max Fonin
Дата:
Сообщение: Enum type emulation: problem with opaque type in PL/pgSQL functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Transaction, Rollback and Database Corruption question,