ISSUE :
 
Profile photo
Submitted by Oracle DBA
on August 25th, 2011 at 14:47:18 EST

How do I change username/password in PostgreSQL 9.x

Hi,
Just installed PostgreSQL 9.x.
It is failing to authenticate me and I don't remember password.
How can I change it?
Thanks,
Oracle


Profile photo
Replied by Yogaraj Khanal
on August 25th, 2011 at 14:53:06 EST

ALTER ROLE postgres WITH PASSWORD 'New&StrongP@ssWord';

See here for more details and customization
Accepted Answer
Accepted
 Answer

Profile photo
Replied by Oracle DBA
on August 26th, 2011 at 09:24:28 EST
Thank you your example worked.