Postgres issues when installing HEM on machine with PT3

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

Post Reply Subscribe

...

07-09-2009 , 10:04 PM

scawtt22

stranger

Join Date: Mar 2009 Posts: 11

Hi guys,

My brother has been using PT3 for a little while, however he saw HEM running on my box and likes it more. We've installed it and hit the point where it asks for Postgres config details.

He doesn't remember having to set up Postgres for PT3 so I assume it auto-installed (I've never used PT3) and set itself up. Therefore, we don't know the database password.

I've uninstalled PT3, and reinstalled Postgres, but the database has remained password protected.

Any ideas? I'm not real experienced with Postgres.. setup on my box for HEM was simple because I'd never had PT3.

Thanks guys

Quote

07-09-2009 , 10:12 PM

JHair

Bagel Man

Join Date: Dec 2008 Posts: 4,407

I believe when you reinstall you can set it to something new, such as:

UN: postgresuser
password: holdem

and this should work. browse the HEM forums and register and make a topic if this doesnt work. I had the same problem but I remember it not being so difficult.

Quote

07-09-2009 , 10:25 PM

scawtt22

stranger

Join Date: Mar 2009 Posts: 11

Yeah when we reinstall Postgres, it comes up with a box where you can enter the details for creating a database if there is no database present. Otherwise it just wants the details for the current database.

I'll create a topic at HEM when I get home from lunch.

Quote

07-09-2009 , 10:30 PM

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

edit pg_hba.conf to "trust" for localhost / 127.0.0.1 and it won't bother checking your password, you can put anything.

Sorry I'm off to sleep so can't elaborate further right now, but those keywords should give you enough info to find my (or others) previous posts detailing exactly how to do this when you return from lunch.

Quote

07-10-2009 , 12:13 AM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,192

I have some suggestions to try and can elaborate on dave's instructions....

But a thread on the HM forums is the best idea, TBH.

Gotta take my dog out, brb........

Quote

07-10-2009 , 12:24 AM

AKingdom

Pooh-Bah

Join Date: May 2007 Posts: 3,520

dbpass is the password that PT3 had set when I installed my HM so you can try that one. The default username was correct.

Quote

07-10-2009 , 12:27 AM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,192

PT3's default name/password is - postgres/dbpass

If that password isn't right, you can try using svcpass, or postgrespass.

If neither of those work, you can remove the need for a password by editing the pg_hba.conf file.

Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

That file should be located in %PROGFILESDIR%\PostgreSQL\8.3\Data

The file should open with Notepad

Scroll to the bottom where you will see this code

Code:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

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

You need to change the first 'md5' to 'trust', like this

Code:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

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

Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration

Let me know how that goes. If he needs further help it would best be handled on the HM Forums.

Quote

Post Reply Subscribe

...