Backup fails due to pg_dump mismatch

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Backup fails due to pg_dump mismatch

Postby BoiledFrog » Tue Mar 12, 2013 10:50 pm

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?
BoiledFrog
 
Posts: 59
Joined: Thu Aug 25, 2011 9:03 am

Re: Backup fails due to pg_dump mismatch

Postby kraada » Wed Mar 13, 2013 7:42 am

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

Re: Backup fails due to pg_dump mismatch

Postby BoiledFrog » Wed Mar 13, 2013 10:51 am

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.
BoiledFrog
 
Posts: 59
Joined: Thu Aug 25, 2011 9:03 am

Re: Backup fails due to pg_dump mismatch

Postby kraada » Wed Mar 13, 2013 12:01 pm

If you change that line in the PokerTracker.cfg file to /usr/bin/ then I think that will do it for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Backup fails due to pg_dump mismatch

Postby BoiledFrog » Wed Mar 13, 2013 12:55 pm

Where do I find the original PokerTracker.cfg file? Or do I have to modify it in the backup file and import it?
BoiledFrog
 
Posts: 59
Joined: Thu Aug 25, 2011 9:03 am

Re: Backup fails due to pg_dump mismatch

Postby kraada » Wed Mar 13, 2013 1:58 pm

It's in ~/Library/Application Support/PokerTracker/ and you can edit it with any text editor.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Backup fails due to pg_dump mismatch

Postby BoiledFrog » Wed Mar 13, 2013 4:07 pm

Cool. That worked. I still get the backwards upgrade message at the start but I don't think that's anything to worry about.
BoiledFrog
 
Posts: 59
Joined: Thu Aug 25, 2011 9:03 am

Re: Backup fails due to pg_dump mismatch

Postby kraada » Wed Mar 13, 2013 5:31 pm

It's not really sounds like you should be good to go.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 8 guests

cron
highfalutin