Upgrade from PT3 to PT4 and get a database connect problem

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

[kraada]

In Applications -> Utilities -> Terminal type ps auxw | grep -i postgres and hit enter and paste the output here for me please.

[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$

[kraada]

That does imply that PostgreSQL is running. Are you still able to connect with PT3?

[MarCro]

Yes, with PT3 I can still see hands from the past. Also, it is using PostgreSQL 9.0.5.

[WhiteRider]

Have you specified the correct port number for the 9.0 service? Use the same port number that PT3 is using.

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

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

[MarCro]

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.

[kraada]

It's in ~/Library/Application Support/PokerTracker/Config/