Upgrade from PT3 to PT4 and get a database connect problem

A special forum dedicated to our PT4 for Mac OS X users

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Upgrade from PT3 to PT4 and get a database connect problem

Postby MarCro » Fri May 10, 2013 2:03 pm

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.
MarCro
 
Posts: 14
Joined: Sun Jan 11, 2009 6:22 pm

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby kraada » Fri May 10, 2013 2:29 pm

In Applications -> Utilities -> Terminal type ps auxw | grep -i postgres and hit enter and paste the output here for me please.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby MarCro » Fri May 10, 2013 2:50 pm

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$
MarCro
 
Posts: 14
Joined: Sun Jan 11, 2009 6:22 pm

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby kraada » Fri May 10, 2013 4:12 pm

That does imply that PostgreSQL is running. Are you still able to connect with PT3?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby MarCro » Fri May 10, 2013 5:25 pm

Yes, with PT3 I can still see hands from the past. Also, it is using PostgreSQL 9.0.5.
MarCro
 
Posts: 14
Joined: Sun Jan 11, 2009 6:22 pm

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby WhiteRider » Sat May 11, 2013 3:59 am

Have you specified the correct port number for the 9.0 service? Use the same port number that PT3 is using.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby MarCro » Sat May 11, 2013 8:32 am

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.
MarCro
 
Posts: 14
Joined: Sun Jan 11, 2009 6:22 pm

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby kraada » Mon May 13, 2013 9:42 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby MarCro » Mon May 13, 2013 10:24 am

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.
MarCro
 
Posts: 14
Joined: Sun Jan 11, 2009 6:22 pm

Re: Upgrade from PT3 to PT4 and get a database connect probl

Postby kraada » Mon May 13, 2013 3:46 pm

It's in ~/Library/Application Support/PokerTracker/Config/
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PT4 for macOS

Who is online

Users browsing this forum: No registered users and 12 guests

cron