Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E6880632788 for ; Thu, 26 Aug 2010 18:11:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 85547-03 for ; Thu, 26 Aug 2010 21:11:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 92F3F632547 for ; Thu, 26 Aug 2010 18:11:50 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 26 Aug 2010 16:11:49 -0500 Message-Id: <4C76923D0200002500034CEB@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Thu, 26 Aug 2010 16:11:41 -0500 From: "Kevin Grittner" To: "Dragos Valentin Moinescu" Cc: Subject: Re: 8.2 "real-time" recovery References: <4C74DB180200002500034B6F@gw.wicourts.gov> <4C74DEE90200002500034B7A@gw.wicourts.gov> <4C74EC500200002500034B81@gw.wicourts.gov> <4C752D610200002500034BC9@gw.wicourts.gov> In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/237 X-Sequence-Number: 35486 Dragos Valentin Moinescu wrote: > I succeded in creating a warm standby server: > > [custom scripting] That's gotta be nicer than what you were doing before. :-) That said, I fear there are a few unusual conditions you are not handling in your script. You might want to take a look at some packaged solutions which deal with these gracefully. pg_standby and pitrtools come to mind, although I might be forgetting something. In the meantime, keep an eye on the log files from both the source and standby databases to make sure transactions are flowing. You might also want to run pg_controldata and make sure that "Database cluster state" is "in archive recovery" and "Time of latest checkpoint" hasn't gotten too stale. -Kevin