High Availability(Failover Clustering) for PostgreSQL on Windows 2008 R2

Anibal David Acosta

2012-09-06 20:39:36 UTC

Install Postgres in both server machine
Configure the MS Cluster Service, add the external storage and the Postgres
Service to your cluster group, and configure the postgres service to start
using the directory in the external storage.

Now you have a fail over database.

Add you application to cluster and you the complete solution.

-----Mensaje original-----
De: pgsql-admin-***@postgresql.org
[mailto:pgsql-admin-***@postgresql.org] En nombre de sradez
Enviado el: jueves, 06 de septiembre de 2012 12:22 p.m.
Para: pgsql-***@postgresql.org
Asunto: [ADMIN] High Availability(Failover Clustering) for PostgreSQL on
Windows 2008 R2

Hello,

We are planning to use Postgresql for one our project where we can 24/7
uptime.

We would like to know if there is a High Availability Solution that can be
implemented on Windows Machines.
We are specially interested in Clustering(Active-Passive Model with DB
sitting on a Shared Drive).

Please let us know if its possible and if so,can you please guide me to the
appropriate sites where i can find more info on implementation part.

Thanks for your time.

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/High-Availability-Failover-Clusterin
g-for-PostgreSQL-on-Windows-2008-R2-tp5723063.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin