Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 8EEFA2E002C for ; Fri, 16 May 2008 13:43:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43681-03 for ; Fri, 16 May 2008 13:43:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web25805.mail.ukl.yahoo.com (web25805.mail.ukl.yahoo.com [217.12.10.190]) by developer.postgresql.org (Postfix) with SMTP id 4D07E2E002F for ; Fri, 16 May 2008 13:43:06 -0300 (ADT) Received: (qmail 69192 invoked by uid 60001); 16 May 2008 16:43:04 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=g9LX3yMk+BS2C7/HED0T4+acxiD8Y6owouaeGfRo0LtrfT2kGuzc2I3Q72HJmKGfD2OWW3wBQ8qyqb2PqFF5/2lrxcQ5Nt8lOV2neh86qqHeyxOPuGwCSYdJCAv466TSDRAE3SfCaDP6vrC0BteMHr6ljJISrudORX6vUZ+CJLU=; X-YMail-OSG: GVXXZ0wVM1mHGCfMOneHukENP0e5bbjnx7pc79XQdnNVgTnBDcSIbzafpNLBAB0_spDEmWqPabDYfbbwj06EaFkRpfeZ6U0GsZd6LDFzVDr6dXk5Jwgjn79gag-- Received: from [213.83.65.106] by web25805.mail.ukl.yahoo.com via HTTP; Fri, 16 May 2008 16:43:04 GMT X-Mailer: YahooMailRC/975.41 YahooMailWebService/0.7.185 Date: Fri, 16 May 2008 16:43:04 +0000 (GMT) From: Glyn Astill Subject: pg_restore test procedures (a bit OT) To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Message-ID: <152155.68667.qm@web25805.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/148 X-Sequence-Number: 29232 Hi chaps,=0A=0AI was just wondering if anyone has any clever way of testing= their backups taken with pg_dump on a daily basis?=0A=0AOn a slightly sepa= rate note,=0A=0AI've setup a daily restore onto a staging server that I int= end to also use to test the dumps, at the moment I've just set up a cron jo= b. I'm sure capturing the output would be sufficient, however I'm having pr= oblems getting it into by logfile.=0A=0Asu - $PGUSER -c "pg_restore -h loca= lhost -U postgres --disable-triggers -c -d $database $backup_dir/$server-$d= atabase-data.gz" >> $logfile=0A=0Aor =0A=0Asu - $PGUSER -c "pg_restore -h l= ocalhost -U postgres --disable-triggers=0A-c -d $database $backup_dir/$serv= er-$database-data.gz >> $logfile"=0A=0Awon't let me capture it.=0A=0AHow du= mb am I?=0A=0A=0A ____________________________________________________= ______=0ASent from Yahoo! Mail.=0AA Smarter Email http://uk.docs.yahoo.com/= nowyoucan.html