Re: Tutorials on high availability Postgresql setup? - Mailing list pgsql-general

From Leonardo Francalanci
Subject Re: Tutorials on high availability Postgresql setup?
Date
Msg-id 979817.32324.qm@web29003.mail.ird.yahoo.com
Whole thread Raw
In response to Re: Tutorials on high availability Postgresql setup?  (Digimer <linux@alteeve.com>)
List pgsql-general
> 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




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_relation_size / could not open relation with OID #
Next
From: Frank Zhao
Date:
Subject: migration from PointBase to PostgreSQL