On 09/02/2015 04:43 PM, ray madigans.org wrote:
I have lost/forgotten the postgres password for my installation so I did
the following.
I edited pg_hba.conf and added an entry:
local all all trust
restarted postgresql.
loged in as postgres (psql template1 -U postgres)
change the postgres password with
ALTER ROLE postgres PASSWORD foo
I edited pg_hba.conf and get rid of the added line
restarted postgres
when I attempted to reenter with
psql template1 -U postgres --password
I get an error Peer authentication failed for user "postgres"
Not sure what I did wrong, any help would be appreciated.
Well in pg_hba.conf first match wins, so I would say you have a line the
uses peer authentication before one that uses md5(password).
Can you show us the contents of the pg_hba.conf file?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
