Thread: High availability with Postgres

High availability with Postgres

From
Date:

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

Re: High availability with Postgres

From
Sameer Thakur
Date:
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.


Re: High availability with Postgres

From
Iñigo Salvat
Date:
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.
>
>



Re: High availability with Postgres

From
Luis Antonio Dias de Sá Junior
Date:
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 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.





--
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