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

[hammerHead]

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

[WhiteRider]

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.

[hammerHead]

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

[WhiteRider]

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

[kraada]

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]

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

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.