We use Pacemaker + heatbeat to linux process like pgpool and Virtual IP. For postgres pgpool have failover process, just set then. See pgpool oficial documentation.
2015-02-18 5:24 GMT-02:00 Iñigo Salvat <inigo@xxxxxxxxxx>:
Hi,
We are using Pacemaker + Corosync + pcs + the latest pgsql Resource Agent.
It is working very nice and the resource agent is able to manage pretty well the streaming protocol so you don't need to share any disk.
Regards,
Iñigo
El 18/02/15 08:12, Sameer Thakur escribió:
Hello,
I am looking for some solution for High availability with Postgres 9.3 onRed Hat Linux Enterprise edition >V6.
Please have a look @ http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster
This solution uses Linux HA components to provide HA to PostgreSQL
configured for streaming replication
regards
Sameer
--
View this message in context: http://postgresql.nabble.com/High-availability-with-Postgres-tp5838373p5838378.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Luis Antonio Dias de Sá Junior