Skip site navigation (1) Skip section navigation (2)

pg_restore test procedures (a bit OT)

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_restore test procedures (a bit OT)
Date: 2008-05-16 16:43:04
Message-ID: 152155.68667.qm@web25805.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-05-16 17:01:30
Subject: Re: Can't reinstall b/c don't know the very long installation password
Previous:From: Jeff FrostDate: 2008-05-16 16:38:27
Subject: Re: Can't reinstall b/c don't know the very long installation password

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group