Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CEB33633C5B for ; Thu, 5 Mar 2009 17:10:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06175-07 for ; Thu, 5 Mar 2009 17:10:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.autorevenue.com (mail.autorevenue.com [208.178.167.106]) by mail.postgresql.org (Postfix) with ESMTP id 13A39632FDF for ; Thu, 5 Mar 2009 17:10:28 -0400 (AST) Received: (qmail 23556 invoked from network); 5 Mar 2009 16:15:03 -0500 Received: from localhost (HELO mail.autorevenue.com) (127.0.0.1) by mail.autorevenue.com with SMTP; 5 Mar 2009 16:15:03 -0500 Received: from 10.10.6.20 (SquirrelMail authenticated user msteben) by mail.autorevenue.com with HTTP; Thu, 5 Mar 2009 16:15:03 -0500 (EST) Message-ID: <41416.10.10.6.20.1236287703.squirrel@mail.autorevenue.com> Date: Thu, 5 Mar 2009 16:15:03 -0500 (EST) Subject: another PITR recovery question From: msteben@autorevenue.com To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.6-1 MIME-Version: 1.0 Content-Type: multipart/mixed;boundary="----=_20090305161503_55393" X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/84 X-Sequence-Number: 31584 ------=_20090305161503_55393 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit I'm running postgres 8.2.5 and I'm running a PITR restore on a remote machine. The archived logs are being restored at a rate of about 5 every 3 minutes I was reading in compressed logs and uncompressing them as they are being restored. I am now reading in uncompressed logs straight into the restore. The restore rate only improved slightly - to the rate of 6 every 3 minutes. Is there something I can do in postgresql.conf or in the shared memory to get this to move faster? At this rate my recovery will run for days as I'm copying WAL logs from my production machine. Thanks Mark Steben Autorevenue ------=_20090305161503_55393 Content-Type: text/html; name="untitled-2" Content-Transfer-Encoding: 8bit Content-Disposition: attachment; filename="untitled-2"

 

 


From: Mark Steben [mailto:msteben@autorevenue.com]
Sent: Thursday, March 05, 2009 3:58 PM
To: 'pgsql-admin@postgresql.org'
Subject: another PITR recovery question

 

I’m running postgres 8.2.5 and I’m running a PITR restore on a remote machine.

The archived logs are being restored at a rate of about 5 every 3 minutes

I was reading in compressed logs and uncompressing them as they are being restored.

I am now reading in uncompressed logs straight into the restore.

The restore rate only improved slightly – to the rate of 6 every 3 minutes.

 

Is there something I can do in postgresql.conf or in the shared memory to

get this to move faster?  At this rate my recovery will run for days as I’m copying

WAL logs from my production machine. 

 

Thanks

 

Mark Steben

Autorevenue

 

------=_20090305161503_55393--