From: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
To: pgsql-admin@postgresql.org
Subject: Re: Heartbeat + pacemaker configuration for PostgreSQL log shipping
Date: Tue, 22 Feb 2011 12:15:21 -0800 (PST)
Message-ID: <1298405721458-3396099.post@n5.nabble.com> (raw)
In-Reply-To: <AANLkTi=z9d0bTDR_YoxuDbuH3k1-yfLw12B6Y9S2R2Zt@mail.gmail.com>
References: <AANLkTi=z9d0bTDR_YoxuDbuH3k1-yfLw12B6Y9S2R2Zt@mail.gmail.com>
Hi,
we spend some time looking to use heartbeat Pg 9.0 and warm standby
replication option to configure a "master/slave" system. At the end we
have implemented DRBD and STONITH for a master Pg server, DRBD is been
used for for all Pg db directories the only exception is the Pg software and
backup directory, so far we like that the fail over procedure is very
simple and time efficient , Pg is in consistency state always after a clean
or "immediate/fast" shutdown ; the downside : this solution is protecting us
only from hardware issues not software/Pg issues aka :Pg data, log files
corruption.
Hope this may help with your decision,
Isabella
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Heartbeat-pacemaker-configuration-for-PostgreSQL-log-shippin...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
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: isabella.ghiurea@nrc-cnrc.gc.ca
Subject: Re: Heartbeat + pacemaker configuration for PostgreSQL log shipping
In-Reply-To: <1298405721458-3396099.post@n5.nabble.com>
* 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