PDA

View Full Version : Can't Get Into Postgres to Do a Vacuum



Chomper4
01-26-2010, 06:32 PM
Im trying to help my brother do a vacuum through postgres and it wont allow me to access the database to do maintenance. HEM works fine and imports his HHs and all of that, but the password or username isnt correct and the postgres and postgrespass arent working. Any idea how to fix this issue?

Hes on a 64 bit Windows XP and is using postgres 8.3.

fozzy71
01-27-2010, 12:42 AM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Res
tart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL)/

Patvs
01-27-2010, 12:51 AM
Open dbcontrolpanel.exe / or Database Management in HM.
Verify the username/password is: postgres/postgrespass.

Open pgAdminIII---> double click the database... when it asks for the password will in the postgres password.

What error do you get when you do it?