Re: can't get user authentication to work - HELP!
От | Peter Eisentraut |
---|---|
Тема | Re: can't get user authentication to work - HELP! |
Дата | |
Msg-id | Pine.LNX.4.21.0011231729400.1355-100000@peter.localdomain обсуждение исходный текст |
Ответ на | can't get user authentication to work - HELP! ("Floyd Shackelford" <floyds@4peakstech.com>) |
Список | pgsql-general |
Floyd Shackelford writes: > 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? Normally you get one with createuser. Perhaps you have two different postmasters running and the createuser command picked the wrong one? > psql -h 192.168.1.200 -d a_database -U postgres -W > and I get: > psql: Password authentication failed for user 'postgres' By default the postgres user doesn't have a password. You need to give it one first. (See ALTER USER.) -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
В списке pgsql-general по дате отправления: