Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7EB122E30AC for ; Fri, 28 Dec 2007 11:38:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 54968-02 for ; Fri, 28 Dec 2007 11:38:00 -0400 (AST) Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 09A6A2E308F for ; Fri, 28 Dec 2007 11:37:59 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 28 Dec 2007 09:37:57 -0600 Message-Id: <4774C3EA.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Fri, 28 Dec 2007 09:37:46 -0600 From: "Kevin Grittner" To: "David F. Skoll" , "Tom Lane" Cc: Subject: Re: Warm-standby robustness question References: <4768081F.90500@roaringpenguin.com><4768081F.90500@roaringpenguin.com> <3149.1198004157@sss.pgh.pa.us> In-Reply-To: <3149.1198004157@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/232 X-Sequence-Number: 27749 >>> On Tue, Dec 18, 2007 at 12:55 PM, in message <3149.1198004157@sss.pgh.p= a.us>, Tom Lane wrote:=20 > "David F. Skoll" writes: >> 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? >=20 > I don't think the time period is at issue. Log-shipping should keep the > slave a perfect replica of the master (if it doesn't, we have problems > anyway). =20 Except for hint bits. This becomes more of a post-recovery performance issue as the base backup ages, since they are included in base backups, but not in WAL files. =20 http://archives.postgresql.org/pgsql-performance/2007-12/msg00203.php =20 > The operational question you need to ask yourself is: if > you haven't swapped to the slave lately, how do you know it will work > when you need it to? =20 Absolutely. Nobody should ever assume they have a working backup system without periodic tests that the backups can actually be used to create a working system. Ever. =20 -Kevin =20