From: Glyn Astill <glynastill@yahoo.co.uk>
To: pgsql-admin@postgresql.org
Subject: pg_restore test procedures (a bit OT)
Date: Fri, 16 May 2008 16:43:04 +0000 (GMT)
Message-ID: <152155.68667.qm@web25805.mail.ukl.yahoo.com> (raw)
Hi chaps,
I was just wondering if anyone has any clever way of testing their backups taken with pg_dump on a daily basis?
On a slightly separate note,
I've setup a daily restore onto a staging server that I intend to also use to test the dumps, at the moment I've just set up a cron job. I'm sure capturing the output would be sufficient, however I'm having problems getting it into by logfile.
su - $PGUSER -c "pg_restore -h localhost -U postgres --disable-triggers -c -d $database $backup_dir/$server-$database-data.gz" >> $logfile
or
su - $PGUSER -c "pg_restore -h localhost -U postgres --disable-triggers
-c -d $database $backup_dir/$server-$database-data.gz >> $logfile"
won't let me capture it.
How dumb am I?
__________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: glynastill@yahoo.co.uk
Subject: Re: pg_restore test procedures (a bit OT)
In-Reply-To: <152155.68667.qm@web25805.mail.ukl.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox