Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 16 May 2008 16:43:04 +0000 (GMT)
- Message-id: <152155(dot)68667(dot)qm(at)web25805(dot)mail(dot)ukl(dot)yahoo(dot)com>
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
- Follow-Ups:
- Re: pg_restore test procedures (a bit OT)
- From: Phillip Smith
- Re: pg_restore test procedures (a bit OT)
- Prev by Date: Re: error message in PITR restore:
- Next by Date: Re: Can't reinstall b/c don't know the very long installation password
- Previous by thread: error message in PITR restore:
- Next by thread: Re: pg_restore test procedures (a bit OT)
- Indexes: