From: | "Martin J(dot) Brown, Jr(dot)" <mjbjr(at)mjbjr(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | can't authenticate pg admin |
Date: | 2004-08-11 10:17:27 |
Message-ID: | pan.2004.08.11.10.17.34.477531@mjbjr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)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(at)mjbjr(dot)com -
Public PGP Key ID: 0x76A1778E keyserver: http://pgpkeys.mit.edu:11371/
Fingerprint: F2D2 5D2B 333F 79D0 D126 0941 21D6 7321 76A1 778E
From | Date | Subject | |
---|---|---|---|
Next Message | Jona | 2004-08-11 13:45:47 | Recover old record version |
Previous Message | Scott Marlowe | 2004-08-11 09:14:32 | Re: Adding multiple instances to 7.4 |