Pageviews

Friday 17 January 2014

How to reset Postgre SQL Database Password

by Unknown  |  in Database at  Friday, January 17, 2014

PostGreSql is the World's most advanced open source database.Postgre SQL can hold a large amount of data,that is what it is known for.But there is big problem related with it,that is with the Superuser password.This problem is basically faced by Windows users because Linux and Mac users does not need password during installation.

90% of the users forget this password,this password is required during installation.Now for all that users,here is the solution for that error.You need not to worry,just follow the below steps:

1.Firstly,run your Command Prompt as Administrator.



2. Now type the following command
net user postgres *

3.Now here you can reset your password,and continue with your Installation of Database.

How to uninstall Postgres ?

Uninstalling Postgres is a simple way to remove Postgres from your System,but this wont remove the SuperUser account from your System.If you want a fresh installation,it will again ask for password.So in order to remove the Superuser account also,you need to execute the following command in the Command prompt.

net user postgres /delete










0 comments:

Proudly Powered by Blogger.