Backup hangs before 4.08.3 database upgrade

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

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

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

[kraada]

It really should, we recommend the backup for extra safety more than anything.

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

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

[BoiledFrog]

Doh! What a blunder! Of course, that's the problem. Now it works perfectly.

[kraada]

Don't feel bad, you did most of the work there for me