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!
Re: can't get user authentication to work - HELP! |
Список | 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 по дате отправления: