April 19th, 2012, 09:01 AM
I'm a new user of Postgres having used other databases (Oracle, Access) in the past. I've installed PostgreSQL 9.1 for Windows on my Win7 machine and have got it running well although with a few educational hiccups on the way. The only learning resource I could get my hands was via Amazon but that is based on version 8 and so therefore is a little out of date though not too badly.
In this book, the author takes one through the psql application found in ..9.1\bin. My problem is that when I run this I am asked for a password in the DOS window which I have forgotten. Is there any way I can either retrieve this password or overwrite it? I suspect that the resources in pgAdmin III could cover for this but I would like to use this so far excellent book as closely as possible. I have looked at the postgresql.conf file and that has:-
#password_encryption = on
which I read as encryption is not enabled as it is commented out which presumably means that the default is off. According to an earlier post here in 2006 this means that it can be accessed. However that post did not help this dilemma, once again seemingly due to versioning differences.
April 19th, 2012, 09:33 AM
Why no use the manual?
Originally Posted by robinw999
Should contain everything you need: http://www.postgresql.org/docs/current/static/index.html
And the PostgreSQL wiki: http://wiki.postgresql.org/wiki/Main_Page
It's not a DOS window. PostgreSQL does not run on DOS. It's a Windows commandline
It's one of the Questions in the PostgreSQL FAQ:
And of course if you search for "postgres reset password" you'll get plenty of hints in the internet. Here are some:
Last edited by shammat; April 19th, 2012 at 09:39 AM.
April 19th, 2012, 06:04 PM