Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id BDB2B2E008C for ; Fri, 20 Jun 2008 11:06:42 -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 87356-01 for ; Fri, 20 Jun 2008 11:06:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by developer.postgresql.org (Postfix) with ESMTP id 8E5C92E0081 for ; Fri, 20 Jun 2008 11:06:36 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 20 Jun 2008 09:06:32 -0500 Message-Id: <485B72D5.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Fri, 20 Jun 2008 09:06:19 -0500 From: "Kevin Grittner" To: "Bhella Paramjeet-PFCW67" , Subject: Re: Warm-standby in 8.2 References: 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-Archive-Number: 200806/178 X-Sequence-Number: 29516 >>> On Thu, Jun 19, 2008 at 6:31 PM, in message , "Bhella Paramjeet-PFCW67" wrote: > we need to monitor the standby database to > check that it is up, it is getting synced every 10 minutes, and that it > is not out of sync with primary database. What would be the best way to > make these checks or what processes to check to make sure that the > archived logs from primary database are continuously getting applied on > the standby database. We run pg_controldata for the warm standby to make sure that "Database cluster state" is 'in archive recovery' and "Time of latest checkpoint" doesn't get too stale. We also run pg_ctl status and make sure that it reports 'server is running'. This can all be scripted. -Kevin