Re: High availability with Postgres

From: Luis Antonio Dias de Sá Junior <luisjunior(dot)sa(at)gmail(dot)com>
To: Iñigo Salvat <inigo(at)isalvat(dot)es>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: High availability with Postgres
Date: 2015-02-18 11:16:33
Message-ID: CA+BNcWYtHtORnDzd+wC+Kv__9RGJ71hyXf-VvyC-o_0YYTJv4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)isalvat(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
Luis Antonio Dias de Sá Junior

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2015-02-18 15:19:57 Re: execution time
Previous Message Kieren Scott 2015-02-18 09:04:31 Running postgres on Ceph