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-shipping-tp3394494p3396099.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.