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

Re: pg_restore test procedures (a bit OT)

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>, pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore test procedures (a bit OT)
Date: 2008-05-19 11:03:28
Message-ID: 885828.61510.qm@web25803.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks Phillip,

I think the source of my problem was me being dumb and only capturing stdout, rather than stderr and stdout! I needed the "2>&1" on the end.




----- Original Message ----
> From: Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
> To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>; pgsql-admin(at)postgresql(dot)org
> Sent: Monday, 19 May, 2008 1:05:03 AM
> Subject: Re: [ADMIN] pg_restore test procedures (a bit OT)
> 
> > I was just wondering if anyone has any clever way of testing their backups
> taken with pg_dump on a daily basis?
> I have a daily bash script to backup of one of my databases to file, then
> file to tape, which I test restore once per week. I've changed some of my
> variables to hard-coded strings to make it shorter and easier to understand
> at a quick read. Yes I know it's kinda fschked but it's working atm. I'll
> tidy it up eventually....
> 
> 
> if [ "$DAY" = "Mon" ] ; then
>     echo "Test restoring database..." >> $LOG_FILE
> 
>     if [ 1 -eq 1 ] ; then
>         # Debugging
>         $ECHO "Restoring from:           ${BACKUP_PATH}"
>         $ECHO "Restoring to Directory:   ${TMPDNAME}"
>         $ECHO "Restore Database:         ${DBNAME}${DATESTRING}"
>         $ECHO "Restore Source File:      ${TMPFILE}"
>     fi
> 
>     echo -n "Extracting database dump from tape... "
>     tar xf /dev/st0 --directory /tmp
>     if [ $? -ne 0 ] ; then
>         echo "FAIL"
>         echo "   Failed to Restore from /dev/st0 to /tmp/" >>
> $LOG_FILE
>         SHOW_ERR=true
>     fi
> 
>     if [ ${SHOW_ERR} != true ] ; then
>         ### Note: $DATESTRING = yymmdd (eg. 080519)
>         echo "Creating new database ${DBNAME}${DATESTRING}" >>
> $LOG_FILE
>         /usr/local/bin/psql --command "CREATE DATABASE
> ${DBNAME}${DATESTRING} ENCODING = 'SQL_ASCII';" > /dev/null
>         if [ $? -eq 0 ] ; then
>             echo "Restoring /tmp/psqldump.sql.502 to
> ${DBNAME}${DATESTRING}" >> $LOG_FILE
>             /usr/local/bin/psql ${DBNAME}${DATESTRING} <
> /tmp/psqldump.sql.502
>         else
>             echo "Failed to Create Database!" >> $LOG_FILE
>             SHOW_ERR=true
>         fi
>     fi
> Fi
> 
> 
> > 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"
> 
> Perhaps something like this: (it's Monday morning, so I might be suggesting
> something stupid)
> LOG=`su - $PGUSER -c "pg_restore -h localhost -U postgres --disable-triggers
> -c -d $database $backup_dir/$server-$database-data.gz"`
> echo $LOG >> $logfile
> 
> 
> THINK BEFORE YOU PRINT - Save paper if you don't really need to print this
> 
> *******************Confidentiality and Privilege Notice*******************
> 
> The material contained in this message is privileged and confidential to
> the addressee.  If you are not the addressee indicated in this message or
> responsible for delivery of the message to such person, you may not copy
> or deliver this message to anyone, and you should destroy it and kindly
> notify the sender by reply email.
> 
> Information in this message that does not relate to the official business
> of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta.
> Weatherbeeta, its employees, contractors or associates shall not be liable
> for direct, indirect or consequential loss arising from transmission of this
> message or any attachments
> e-mail.
> 
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin



      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

pgsql-admin by date

Next:From: Chander GanesanDate: 2008-05-19 15:07:58
Subject: Re: Global / cluster-wide functions
Previous:From: Phillip SmithDate: 2008-05-19 00:05:03
Subject: Re: pg_restore test procedures (a bit OT)

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