Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5E2242E0065 for ; Tue, 18 Dec 2007 13:49:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 27550-06 for ; Tue, 18 Dec 2007 13:49:50 -0400 (AST) Received: from www.roaringpenguin.com (www.roaringpenguin.com [206.191.13.82]) by postgresql.org (Postfix) with ESMTP id EE0652E0037 for ; Tue, 18 Dec 2007 13:49:20 -0400 (AST) Received: from magnesium.roaringpenguin.com (ottawa-hs-64-26-171-99.s-ip.magma.ca [64.26.171.99]) by www.roaringpenguin.com (8.14.2/8.14.0) with ESMTP id lBIHnJgW000825 for ; Tue, 18 Dec 2007 12:49:19 -0500 Received: from [192.168.10.1] (hydrogen.roaringpenguin.com [192.168.10.1]) by magnesium.roaringpenguin.com (8.12.10/8.12.10) with ESMTP id lBIHnJNu029577 for ; Tue, 18 Dec 2007 12:49:19 -0500 Message-ID: <4768081F.90500@roaringpenguin.com> Date: Tue, 18 Dec 2007 12:49:19 -0500 From: "David F. Skoll" User-Agent: Thunderbird 2.0.0.5 (X11/20070716) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Warm-standby robustness question X-Enigmail-Version: 0.95.5 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Scanned-By: CanIt (www . roaringpenguin . com) on 206.191.13.82 X-Scanned-By: MIMEDefang 2.57 on 192.168.10.12 X-CanItPRO-Stream: outgoing (inherits from default) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/167 X-Sequence-Number: 27684 Hi, We have two PostgreSQL 8.2 database servers: A master and a warm-standby server. We plan on making an initial backup of the master onto the standby and then use log-shipping with "real-time" WAL-file processing as described in http://www.postgresql.org/docs/8.2/static/warm-standby.html My question is this: If the master database is fairly busy, gets VACUUMed once a day, etc. can we expect the warm standby server to work correctly after days/weeks/months/years of log shipping, or should we periodically take new base backups? How long would you go between base backups? Or is one initial copy really sufficient with WAL-shipping-and-consuming working perfectly thereafter? Regards, David.