Link to home
Start Free TrialLog in
Avatar of Steve Randazzo
Steve RandazzoFlag for United States of America

asked on

Simple and easy way to change admin password. - PGAdmin/PostGre Sql 9.3

need a simple and direct method to rename the admin account for PostGre-SQL 9.3. I am using the pgadmin application but cant get the password changed. I wonder if there is an alternate way for me to get this process done. maybe the SQL Shell or something else in the actual PGAdmin suite. recently lost access to the admin account for this Postgre Sql. I have been reading around on ways to get it done but none of them seemed to work out for me yet.
Avatar of earth man2
earth man2
Flag of United Kingdom of Great Britain and Northern Ireland image
As system administrator ie root or Administrator set the os password for the PostgreSQL superuser, usually postgres.  Run psql command line utility as user postgres.  Within psql pseudo command  \password can be used to set the PostgreSQL  admin password.

Try that.  The admin user might not be postgres in a custom environment.
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image
recently lost access to the admin account for this Postgre Sql This normally entails a rebuild.  There should be no way to hack your way and get admin creds on the database.

My thinking is (1) backup all of the databases, restore the Potsgres SQL server to a time where you KNOW the admin password or do a reinstall using new credentials. Lastly import the databases into the server.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.