Snapckp

From PTAGISWiki

Ingres backups are performed by taking snapshot checkpoints with the command:

/usr/ingres/run_snapckp.sh 

which is called by root's crontab on blueback or sockeye.

The most recent checkpoint files are kept here:

blueback:/usr/ckp/ingUI/ingres/ckp/default/ptagis3

and here:

sockeye:/usr/ckp/ingUI/ingres/ckp/default/ptagis3

snapckp is not configured to run on sockeye, so merely activating it in root's crontab as it is on blueback will only cause this to appear in /home/pittag/log/job_log:

/usr/ingres/run_snapckp.sh: SKIPPING  snapckp at Tue Oct 20 22:00:00 PST 2009

The recommended method for performing checkpoints on sockeye is to manually use the ckpdb on each database:

ckpdb iidbdb -l -j 
ckpdb design -uptagdev -l -j
ckpdb ptagis3 -upittag -l -j '#m8'

Further documentation on snapckp can be found here: Image:Snapckp checkpoints by splitting mirrors.pdf