forgot Postgres password. - Gambling and Poker Software Forum

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software General Software Discussion

forgot Postgres password.

Post Reply Subscribe

...

08-20-2011 , 03:34 PM

Durgoblin

stranger

Join Date: Aug 2011 Posts: 4

i uninstalled Postgres like 3 month ago, now if i want to install it again, it asks me database superuser password, but i dont remember it. is there anyway i can restore password ? or see it somewhere in my pc ? cant leave password blank also, and ive tryied all the passwords i can remember .

many thanks for help, and sorry for my english .

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

08-20-2011 , 04:25 PM

ChazDazzle

adept

Join Date: Aug 2005 Posts: 947

Try dbpass maybe?

Quote

08-20-2011 , 04:45 PM

ra]\\[dom

adept

Join Date: Mar 2007 Posts: 923

If you installed with HM or PT3, try dbpass or postgrespass

You can log in without password if you follow this:
1) Open Notepad as admin, right click start as admin
2) Go to your postgress installation directory, on 64bit windows default is:
c:\Program Files (x86)\PostgreSQL\8.4\data\
3) Look for file called pg_hba.conf, and open it
4) Scroll down and change your file where it says md5 to trust, so it looks like:

Code:

# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust

5) Save and overwrite the file
6) Go to Start menu>Postgres>Reload configuration
6) Now you can log in to postgress with any password you want

Quote

01-08-2012 , 05:35 PM

SI-KICK

old hand

Join Date: Nov 2007 Posts: 1,354

i love the search function on this site

Quote

01-09-2012 , 12:49 AM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,222

Quote:

Originally Posted by SI-KICK

i love the search function on this site

You might be the first person to ever say that.

I prefer to use google:

[search keywords] site:twoplustwo.com

Quote

01-10-2012 , 05:31 AM

aNtI_gRaViTy

newbie

Join Date: Sep 2011 Posts: 27

If this is because you were using PokerTracker take a look at setting it up again in the help pages as the passwords are there.

Why not simply reinstall if not? Don't forget to delete the data directory as this holds your passwords as well as data - which I'm presuming you don't want. It doesn't get deleted automatically.

My apologies just seen the passwords quoted above.

Quote

01-11-2012 , 03:36 PM

MegaDisgruntled

old hand

Join Date: May 2006 Posts: 1,396

postgrespass is usually the default.

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

Post Reply Subscribe

...