Page 1 of 2
Upgrade from PT3 to PT4 and get a database connect problem
Posted:
Fri May 10, 2013 2:03 pm
by MarCro
I upgraded from PT3 to PT4 on my iMac with no problems.
I then tried to upgrade to from PT3 to PT4 on my Macbook Pro and when I push the connect button on the Configure PostgreSQL Server box I get the following message "Unable to connect to this database. Please check the configuration."
The PostgreSQL Server Information is:
Server: localhost
database user: postgres
Port: 5432
Password: dbpass
In my applications I have folders for PostgreSQL 8.4 and 9.0.
I have seen other threads which have reported this problem but have not been able to fix this from reading them.
Your help with this will be greatly appreciated.
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Fri May 10, 2013 2:29 pm
by kraada
In Applications -> Utilities -> Terminal type ps auxw | grep -i postgres and hit enter and paste the output here for me please.
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Fri May 10, 2013 2:50 pm
by MarCro
Last login: Fri May 10 18:47:01 on console
mark-pc:~ mrkcrckr$ ps auxw | grep -i postgres
postgres 705 0.0 0.1 2491752 5636 ?? SN 7:13pm 0:00.07 /System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Versions/A/Support/mdworker -s mdworker -c MDSImporterWorker -m com.apple.mdworker.shared
postgres 351 0.0 0.0 2506700 1360 ?? S 6:48pm 0:00.10 /usr/sbin/cfprefsd agent
postgres 349 0.0 0.0 2524780 1772 ?? S 6:48pm 0:00.05 /usr/sbin/distnoted agent
postgres 346 0.0 0.0 2508236 1004 ?? Ss 6:48pm 0:00.06 /sbin/launchd
postgres 128 0.0 0.0 2443612 544 ?? Ss 6:46pm 0:00.10 postgres: stats collector process
postgres 127 0.0 0.0 2480824 1780 ?? Ss 6:46pm 0:00.16 postgres: autovacuum launcher process
postgres 126 0.0 0.0 2480692 616 ?? Ss 6:46pm 0:00.33 postgres: wal writer process
postgres 125 0.0 0.0 2480692 1108 ?? Ss 6:46pm 0:00.46 postgres: writer process
postgres 99 0.0 0.0 2443612 368 ?? Ss 6:46pm 0:00.10 postgres: logger process
postgres 62 0.0 0.1 2480692 5152 ?? Ss 6:46pm 0:00.19 /Library/PostgreSQL/9.0/bin/postmaster -D/Library/PostgreSQL/9.0/data
mrkcrckr 757 0.0 0.0 2432768 632 s000 R+ 7:49pm 0:00.00 grep -i postgres
mark-pc:~ mrkcrckr$
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Fri May 10, 2013 4:12 pm
by kraada
That does imply that PostgreSQL is running. Are you still able to connect with PT3?
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Fri May 10, 2013 5:25 pm
by MarCro
Yes, with PT3 I can still see hands from the past. Also, it is using PostgreSQL 9.0.5.
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Sat May 11, 2013 3:59 am
by WhiteRider
Have you specified the correct port number for the 9.0 service? Use the same port number that PT3 is using.
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Sat May 11, 2013 8:32 am
by MarCro
Yes, both are using port 5432, user postgres and server local host. I got the PT3 info by clicking Database\Database Management. I do not remember making any changes to the password.
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Mon May 13, 2013 9:42 am
by kraada
Open up the PokerTracker.cfg file in TextEdit (or any other text editor) and the password will be displayed there - if it's not dbpass, use the password listed there in PT4 and it should work.
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Mon May 13, 2013 10:24 am
by MarCro
kraada wrote:Open up the PokerTracker.cfg file in TextEdit (or any other text editor) and the password will be displayed there - if it's not dbpass, use the password listed there in PT4 and it should work.
I could not find PokerTracker.cfg. I even used the search function in Finder and it did not find it.
Re: Upgrade from PT3 to PT4 and get a database connect probl
Posted:
Mon May 13, 2013 3:46 pm
by kraada
It's in ~/Library/Application Support/PokerTracker/Config/