Retrieve postgres password - Mailing list pgsql-general

From ray madigans.org
Subject Retrieve postgres password
Date
Msg-id 1181547181.26300.1441237404104.JavaMail.vpopmail@atl4oxapp105.mgt.hosting.qts.netsol.com
Whole thread Raw
Responses Re: Retrieve postgres password
List pgsql-general
I have lost/forgotten the postgres password for my installation so I did the following.I edited pg_hba.conf and
added anentry: local all all trustrestarted postgresql. loged in as postgres (psql template1 -U postgres) change
thepostgres password withALTER ROLE postgres PASSWORD fooI edited pg_hba.conf and get rid of the
added linerestartedpostgreswhen I attempted to reenter with  psql template1 -U postgres --passwordI get an
errorPeer authentication failed for user "postgres"Not sure what I did wrong, any help would be
appreciated. 

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: get first and last row in one sql as two columns
Next
From: Melvin Davidson
Date:
Subject: Re: get first and last row in one sql as two columns