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

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.

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.

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.

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........

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

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

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


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.