From: Hannes Dorbath <light@theendofthetunnel.de>
To: Keaton Adams <kadams@mxlogic.com>
Subject: Re: A way to query last checkpoint record and WAL log through SQL?
Date: Sat, 05 May 2007 10:16:50 +0200
Message-ID: <463C3D72.5020500@theendofthetunnel.de> (raw)
In-Reply-To: <0B34A6972BF39E4CB465A64DBBAD2BB901E32E35@mxlhq-exch01.corp.mxlogic.com>
References: <0B34A6972BF39E4CB465A64DBBAD2BB901E32E35@mxlhq-exch01.corp.mxlogic.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: light@theendofthetunnel.de, kadams@mxlogic.com
Subject: Re: A way to query last checkpoint record and WAL log through SQL?
In-Reply-To: <463C3D72.5020500@theendofthetunnel.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox