Backing up PT2/PT3 on a linux server???

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Backing up PT2/PT3 on a linux server???

Postby hammerHead » Sat Sep 13, 2008 12:41 am

I'm looking to start doing regular backups on my Linux server, which is running Postgres and has all my poker stats.

As I am reading the documentation for Postgres db, I see this option:

<snip..snip>

-o
--oids

Dump object identifiers (OIDs) as part of the data for every table. Use this option if your application references the OID columns in some way (e.g., in a foreign key constraint). Otherwise, this option should not be used.

<snip..snip>

My question is, does PT2 or PT3 use "foreign key constants"?
Would the developers recommend I use this option to backup Postgres for both PT2/PT3?

Thanks.
Jeff
hammerHead
 
Posts: 51
Joined: Sun May 25, 2008 3:47 am

Re: Backing up PT2/PT3 on a linux server???

Postby WhiteRider » Sat Sep 13, 2008 4:41 am

I'll try to get someone to answer this for you, but to back up databases..
In PT2, use the postgres options on the Utilities menu.
For PT3, back up functions are not yet built in, but the command line you use to back up is listed at the end of the Database / Postgres FAQ.
WhiteRider
Moderator
 
Posts: 53416
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Backing up PT2/PT3 on a linux server???

Postby hammerHead » Sat Sep 13, 2008 6:04 pm

WhiteRider,

Thanks for your quick response.

I am looking for a backup method without human intervention, much like my network backup plan. Create a cron job to do it every so often, without the need for me to remember if and when I did the backup last?

I'll wait till I hear back about my previous post..

Jeff
hammerHead
 
Posts: 51
Joined: Sun May 25, 2008 3:47 am

Re: Backing up PT2/PT3 on a linux server???

Postby WhiteRider » Sun Sep 14, 2008 4:02 am

I'm sure you could run the command line backup automatically, but one of the other support guys uses linux, so I'll get him to look in..
WhiteRider
Moderator
 
Posts: 53416
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Backing up PT2/PT3 on a linux server???

Postby kraada » Mon Sep 15, 2008 10:55 am

Sorry for taking so long to get to this one.

This script will back up all of your PostgreSQL databases into one gzipped file, which would have a filename looking something like postgresql-backup-Sep15.2008.gz:

Code: Select all
#!/bin/bash
D=`date +%b%d.%Y`
su postgres -c 'pg_dumpall | gzip - > postgresql-backup-$D.gz'


You can run it as often as you'd like; personally I'd expect that weekly would be plenty often enough but it's entirely up to you. This script will need to be run as root.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Backing up PT2/PT3 on a linux server???

Postby hammerHead » Tue Sep 16, 2008 1:34 pm

Kraada,

Thanks for your response.

Have you tested the restore procedure to make sure everything is working like it should? If I read the manuals correctly, you must create the database before restoring the backup, correct?

Jeff


kraada wrote:Sorry for taking so long to get to this one.

This script will back up all of your PostgreSQL databases into one gzipped file, which would have a filename looking something like postgresql-backup-Sep15.2008.gz:

Code: Select all
#!/bin/bash
D=`date +%b%d.%Y`
su postgres -c 'pg_dumpall | gzip - > postgresql-backup-$D.gz'


You can run it as often as you'd like; personally I'd expect that weekly would be plenty often enough but it's entirely up to you. This script will need to be run as root.
hammerHead
 
Posts: 51
Joined: Sun May 25, 2008 3:47 am


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 6 guests

cron
highfalutin