I'd like to run querries and stuff. I thought my PostgreSQL password was postgres but when I open the psql (elephant) terminal, it quickly closes after entering my password. It may have said fatal error? help please
I'd like to run querries and stuff. I thought my PostgreSQL password was postgres but when I open the psql (elephant) terminal, it quickly closes after entering my password. It may have said fatal error? help please
Start HM > Options > Database Management > Password
showed me my password: postgres. C:\Program Files\PostgreSQL\8.3\bin, here is where the psql interactive terminal is (elephant). I enter it but it promptly closes the window. The cursor doesn't move but I understand that that is normal.
please advise.
Use any user/pass for PostgreSQL
FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL)
Trying to download latest Postgres, don't know the password. Tried opening HM, Options, Data Manage, and I get a message that HEM needs to shut down?
Had Postgres download shut down while trying this.
???????
You shouldnt need a password to download postgres.
That sounds like a problem with HM, and not Postgres.Tried opening HM, Options, Data Manage, and I get a message that HEM needs to shut down?
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass
Start HM > Options > Database Management > Password:
If that doesnt help:
1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba f
ile 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. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services
HM will accept any password now.
FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL))
I did this:
______________
You can't retrieve your username and password, but you can edit the pg_hba.conf file so any username and password will work.
To edit the pg_hba.conf file, do the following:
1.Go to C:\Program Files\PostgreSQL\8.x\data, move the pg_hba file to your Desktop and open it with notepad.
2.Scroll to the bottom and change all md5 references to trust. Save and close the file.
______________
now, I cannot open psql. when I look up the Database Control Panel in HEM it says my Login Name is postgres, PW: postgres.
I'd still like to open the psql terminal and enter my password to run querries and such. please advise.
If you did those instructions you should be able to enter any password without issue.