Обсуждение: High availability with Postgres
Hi All,
I am looking for some solution for High availability with Postgres 9.3 on Red Hat Linux Enterprise edition V6.
Will “Symantec™ Storage Foundation Cluster File System HA (SFCFSHA)” product can be fitted for above requirement?
As our customer has this product and asking our recommendation on this. Please help me. If anyone has good links to read more please share.
Regards
Shyamkant
Hello, >I am looking for some solution for High availability with Postgres 9.3 on Red 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.
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 on > Red 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. > >
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@isalvat.es>:
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Luis Antonio Dias de Sá Junior