Page 1 of 1

Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 12:49 am
by BoiledFrog
I chose to backup my database before upgrading the database required for 4.08.3. It's hanging; I tried hitting "Cancel" but it didn't do anything. I can see the backup .zip file in finder but it is zero size and hasn't changed in 20 minutes. I got a message about needing to upgrade to an older version of Postgres but since I already have a later version than required I ignored that message. What should I do?

Re: Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 2:43 am
by WhiteRider
What version of PostgreSQL do you have?
v9.0 is our recommended version and any newer versions (9.1, 9.2, 9.3) can cause problems - if you are using one of these you will need to revert to 9.0.

Re: Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 9:44 am
by BoiledFrog
I have 9.0.13. This is the "upgrade" message I am getting:

PostgreSQL version 9.0.13 on x86_64-apple-darwin11.4.2 is installed. It is recommended to upgrade to at least version 8.3 for Backup/Restore


I just tried to cancel out of it but now it's doing a database update without doing a backup. I hope it works.

Re: Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 10:06 am
by kraada
It really should, we recommend the backup for extra safety more than anything.

Re: Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 10:11 am
by BoiledFrog
The upgrade appears to have worked. Now I am trying the backup again. I am getting the following message:

Can't Find: /Library/PostgreSQL/8.4/bin/pg_dump

This file is normally contained in /Library/PostGreSQL/x.x/bin. If you are using a remote install of PostgreSQL, you will need to install PostgreSQL on your local computer or, if possible and compatible, find this application file on the server.


Since I use MacPorts for Postgres, my pg_dump is in /opt/local/lib/postgresql90/bin/pg_dump. I tried to "Find" it but it won't allow me to select it.

I then added the following section to ~/Library/Application Support/PokerTracker 4/Config:

Code: Select all
[Directories]
ManualImportFile=*
ManualImportDirectory=/Users/Stephen/Documents/PokerTracker/Processed/PokerStars/2011/11-17
PostgresBin=/Library/PostgreSQL/8.4/bin
BackupDirectory=/Users/Stephen/Documents/Poker

which I copied from my PT3 configuration. Still, no joy.

Re: Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 11:25 am
by kraada
Well you'd want to change:
PostgresBin=/Library/PostgreSQL/8.4/bin
to the proper directory:
PostgresBin=/opt/local/lib/postgresql90/bin

Does that help any?

Re: Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 11:46 am
by BoiledFrog
Doh! What a blunder! Of course, that's the problem. Now it works perfectly.

Re: Backup hangs before 4.08.3 database upgrade

PostPosted: Tue Jun 04, 2013 12:51 pm
by kraada
Don't feel bad, you did most of the work there for me ;)

highfalutin