can't authenticate pg admin
От | Martin J. Brown, Jr. |
---|---|
Тема | can't authenticate pg admin |
Дата | |
Msg-id | pan.2004.08.11.10.17.34.477531@mjbjr.com обсуждение исходный текст |
Ответы |
Re: can't authenticate pg admin
|
Список | pgsql-admin |
I've had this problem with 7.3.3, and now with 7.4.3. ... The pg admin is the default 'postgres'. As 'postgres', I do... postgres@localhost postgres $ 'psql -d template1' Welcome to psql 7.4.3, the PostgreSQL interactive terminal. template1=# alter user postgres password 'xyz' template1=# I exit 'psql'. I then edit 'pg_hba.conf', changing from 'trust' to 'password'. I stop, then start pg. I then do 'psql -d template1', which results in a password prompt. I enter 'xyz', and get an authentication error for user "postgres". Other db users authenticate fine, only the admin fails. Any ideas on how to fix this? -- - Martin J. Brown, Jr. - - mjbjr@mjbjr.com - Public PGP Key ID: 0x76A1778E keyserver: http://pgpkeys.mit.edu:11371/ Fingerprint: F2D2 5D2B 333F 79D0 D126 0941 21D6 7321 76A1 778E
В списке pgsql-admin по дате отправления: