PokerTracker

Hey guys,

When opening PT3 (I don't think it's relevant, but for now I have the trial version), an error message comes back regarding signing in to the database:

' Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres" '.

When I installed it, it worked fine and I haven't touched the default settings since. I have tried typing a few default passwords as suggested in the forum,
but to no avail.

I also found reference to disabling the password requirement for postgreSQL, but only for PC and I am on a Mac.
Thanks for your help.

The tutorial here is for a PC but the file still exists on the Mac side.

Run Applications -> Utilities -> Terminal and at the terminal type:

sudo su -

Hit enter, type your mac password (it doesn't show *s, that is normal, just type) and hit enter.

The prompt will change indicating success.

Then type:
nano /Library/PostgreSQL/8.4/data/pg_hba.conf
and hit enter.

You'll find yourself editing the file in the tutorial - edit it as the tutorial explains, then press ctrl+o and enter to save the file then ctrl+x to exit and you can close the window. Restart your computer once and everything should work for you.

thanks kraada, it's working now.

Hey

I had the same Problem, changed all 3 entries from md5 to trust, saved and restarted postgresql. It still wont work, what did i do wrong?

Make sure there are no #s at the front of the line, that would cause it to not be interpreted.

Ok i deleted the #s. When i open PT3 after that there still appears a window "configure postgresql database"and it wants me to either connect to a db or create a new one. whatever i do i still get the same error as before editing the config file

Did you restart PostgreSQL after making the change and saving the file? That is necessary. Is it possible you installed PostgreSQL on a different port?

PostgreSQL V8.3

I used this site to help me delete all pokertracker and postgreSQL files on my laptop one day. I run windows 7. I downloaded it again. Initially I changed the user which is by default "postgres" to "stained". This did not work, A) because stained is not a user that can be used apparently it has to be "postgres" for password initially it was saying it couldnt log me in, standard password error as well : ' Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres" and "stained".

changed user back to "postgres", modified password to "off" using this:

I used https://www.pokertracker.com/forums/vie ... =45&t=4510 to modify the password setting (MD5 to "trust") and now it seems to be working fine. will continue to monitor and report any other problems.


unfortunately for me i had to re enter my registration code upon reinstallation of pokertracker.

For what it's worth, using your registration code again isn't a problem - the only limitation is on the number of current active registrations you have going. Using it twice on the same machine after reinstalling isn't going to cause any problems.

I also get this error message when I try to open PT4 (Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"). I was getting this error message a week ago, found this thread, followed the instructions to edit pg_hba.conf in Terminal, and got my PT4 working fine. However, after a week of successfully using PT4, this morning when I tried to open it I got the same error message. I assume I don't need to edit the file again, any suggestions?