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
capt=
uring the output would be sufficient, however I'm having problems getting
i=
t 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=20
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
--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
