> One option would be to create a simple 2-node cluster and run your PgSQL
> server in a migrateable VM backed by a SAN or, if your budget is more
> modest, a simple DRBD device.
>
> Personally, I like to use RHCS (Red Hat Cluster Services) with a DRBD
> array becking clustered LVM with Xen VMs (domU) on dedicated LVs. This
> doesn't dictate the OS version hosting postgres though, so if you've got
> a particular set of requirement, you can meet them.
>
> Then in the case of planned outage, you can hot-migrate your VM to the
> other node. In the case of catastrophic failure, the surviving node can
> boot the PgSQL server and it would come back as if it had simply lost
> power.
I'm interested in the subject... can you explain a little more the setup?
Thank you