PostgreSQL Installation Help - Gambling and Poker Software Forum

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

PostgreSQL Installation Help

Post Reply Subscribe

...

01-31-2009 , 05:27 AM

gryphon_gold

adept

Join Date: Jun 2007 Posts: 776

I'm trying to re-install it, but I don't know what the password is. How do I get past this part.

Quote

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

Join the action now

Daily Rewards • Splash Pots • CoinRaces

01-31-2009 , 05:45 AM

gryphon_gold

adept

Join Date: Jun 2007 Posts: 776

Quote:

You must set the postgresql authentication mode for localhost (127.0.0.1) to "trust".

Do this:
Click: "Start -> Programs -> PostgreSQL 8.x -> Configuration files -> Edit pg_hba.conf"

It will open a notepad with some text.

Scroll all the way to the bottom, you should see a line reading this:
Code:

#IPv4 local connections:
host all all 127.0.0.1/32 md5

Edit the "md5" to "trust", no quotes. It should now read:

Code:

#IPv4 local connections:
host all all 127.0.0.1/32 trust

Save the pg_hba.conf file, and close notepad.

Click: "Start -> Programs -> PostgreSQL 8.x -> Reload configuration

I tried this, but PostgreSQL isn't on my Start->Programs list, so I had to go through My Computer to find the configuration file. I changed "md5" to "trust". However, I can't figure out how to reload the configuration.

Quote

01-31-2009 , 10:19 AM

thebeezer

grinder

Join Date: Jan 2008 Posts: 507

go to the HEM or PT3 forums

Quote

01-31-2009 , 10:21 AM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,222

default passwords are:

dbpass for pt3

postgrespass for HM/pt2

Quote

01-31-2009 , 11:43 AM

gryphon_gold

adept

Join Date: Jun 2007 Posts: 776

Neither of those passwords work.

Quote

01-31-2009 , 11:49 AM

gryphon_gold

adept

Join Date: Jun 2007 Posts: 776

I searched the PT3 forum and found a suggestion to use this as the password: 'svcpass'. It worked.

Quote

01-31-2009 , 05:20 PM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,222

Quote:

Originally Posted by gryphon_gold

I searched the PT3 forum and found a suggestion to use this as the password: 'svcpass'. It worked.

too bad you didnt do that before making this thread.

Quote

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

Join the action now

Daily Rewards • Splash Pots • CoinRaces

Post Reply Subscribe

...