Backup fails due to pg_dump mismatch

[BoiledFrog]

I am trying to backup my PT3 database. I select "Backup" from the "" dialog. I get the following pop-up

Code: Select all

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

Since 9.0.10 is greater than 8.3 I ignore it and move on.

The backup appears to complete but there's an error in the Status window:

Code: Select all

Database:PT3 DB on Laptop...pg_dump: server version: 9.0.10; pg_dump version: 8.4.2
pg_dump: aborting because of server version mismatch

If I look in the zip file, there's nothing in there that looks like a database backup:

Code: Select all

  Length     Date   Time    Name
 --------    ----   ----    ----
     3088  03-12-13 19:44   Optional/PokerTracker.cfg
   258679  03-12-13 19:44   Optional/Layouts.pt3
    78269  03-12-13 19:44   Optional/ReportsCustomized.pt3
    30282  03-12-13 19:44   Optional/StatDefinitionsCustomized.pt3
      176  03-12-13 19:44   Optional/PokerStars.cfg
      169  03-12-13 19:44   Optional/Buddies.cfg
      533  03-12-13 19:44   TOC.xml
 --------                   -------
   371196                   7 files


I can backup the database manually using the following command:

Code: Select all

/usr/bin/pg_dump -U postgres -h 192.168.1.104 "PT3 DB" > pt3-dump

This gives me 110M file (uncompressed) which is closer to what I expect.

I am running 3.14.3 on a Mac. How can I fix this?

[kraada]

You must have PostgreSQL 8.4 installed at least partially somewhere - that error means that the pg_dump that PT3 is using is the pg_dump from 8.4 not 9.0. Make sure the PT3 defaults are set to your 9.0 install (you can check those in the PokerTracker.cfg file directly - it's just a text file. You could also run the command "which pg_dump" to see where PT might be looking - replacing that version with the 9.0 version might be the ghetto way to get your backup done.

That said, the backup method you used should work also. But do realize that PT4 won't restore from that backup - it needs to convert the data via export and import (though backing things up in general is good!).

[BoiledFrog]

which pg_dump shows /usr/bin/pg_dump. The version of this file is 9.0.5. The PokerTracker.cfg file in the zip file is showing:

Code: Select all

PostgresBin=/Library/PostgreSQL/8.4/bin


So, it is using an old install of PostGres. However, Spotlight can't find the "live" version of the file that PokerTracker is using so I can modify it to point to the correct path.

[kraada]

If you change that line in the PokerTracker.cfg file to /usr/bin/ then I think that will do it for you.

[BoiledFrog]

Where do I find the original PokerTracker.cfg file? Or do I have to modify it in the backup file and import it?

[kraada]

It's in ~/Library/Application Support/PokerTracker/ and you can edit it with any text editor.

[BoiledFrog]

Cool. That worked. I still get the backwards upgrade message at the start but I don't think that's anything to worry about.

[kraada]

It's not really sounds like you should be good to go.