Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BA53F9FB2BA for ; Sat, 5 May 2007 05:33:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 34324-03 for ; Sat, 5 May 2007 05:33:28 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 5AD419FB280 for ; Sat, 5 May 2007 05:33:28 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l458XNMc053299 for ; Sat, 5 May 2007 05:33:23 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l458GmpI088003 for pgsql-admin@postgresql.org; Sat, 5 May 2007 05:16:48 -0300 (ADT) (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: A way to query last checkpoint record and WAL log through SQL? Date: Sat, 05 May 2007 10:16:50 +0200 Organization: Hub.Org Networking Services Lines: 13 Message-ID: <463C3D72.5020500@theendofthetunnel.de> References: <0B34A6972BF39E4CB465A64DBBAD2BB901E32E35@mxlhq-exch01.corp.mxlogic.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Keaton Adams User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) In-Reply-To: <0B34A6972BF39E4CB465A64DBBAD2BB901E32E35@mxlhq-exch01.corp.mxlogic.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/48 X-Sequence-Number: 25368 Keaton Adams wrote: > I'm working to set up a high-availability PostgreSQL server using WAL > shipping. Well, I have no answer to your question, but IMHO DRBD is usually the better approach for PG-HA. It's easy to setup, you don't lose a single commit, no such headaches, no custom scripts and no hacks required. You can still use PITR with it. -- Best regards, Hannes Dorbath