High Availability Cluster

From: Maila Fatticcioni <mfatticcioni(at)mbigroup(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: High Availability Cluster
Date: 2014-11-27 11:26:10
Message-ID: 54770A52.4050500@mbigroup.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello.
I need to set up a high availability cluster with two servers. I have
looked for the best configuration I could use but I cannot find
anything I like. I cannot used the DRBD option and I have to use
Ubuntu 14.04 as OS.
In the past I have set up some clusters using the replication of
Postgresql 9.3. I put one node as master and one node as an hot
standby replication. To complete the installation I have configured
Heartbeat + Pacemaker in order to manage the relocation of the virtual
IP used by the master node and the relocation from the master to the
slave instance of Postgresql.

I was wondering if there is another way to set up a complete cluster
that would manage in case of failure:

* the relocation of the VIP (virtual ip address)
* the relocation of the main instance of Postgresql

Best Regards,
Maila Fatticcioni
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlR3CkgACgkQi2q3wPb3FcNKWACgqfpq7+z7h7qK3z2+H9Qg4Cdw
KWkAn0e1cjtVshTTRYt2GEtt5Wa4FRfz
=5ea1
-----END PGP SIGNATURE-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2014-11-27 11:34:40 Re: High Availability Cluster
Previous Message Andreas Kretschmer 2014-11-27 09:59:24 PostgreSQL and Ideara R1Soft - Backup