Postgres Pro
Downloads
Home   >   mailing lists

Re: Asynchronous streaming replication in postgresql - Mailing list pgsql-cluster-hackers

From Simon Riggs
Subject Re: Asynchronous streaming replication in postgresql
Date
Msg-id CA+U5nMK7jWSp3tx5Ab_UMHyQ2-MxyY3Jr7PNWMAVxaQ20=AHqQ@mail.gmail.com
Whole thread Raw
In response to Re: Asynchronous streaming replication in postgresql  ("Deole, Pushkar (Pushkar)" <pdeole@avaya.com>)
List pgsql-cluster-hackers
Tree view 
On 13 March 2015 at 10:28, Deole, Pushkar (Pushkar) <pdeole@avaya.com> wrote:
> Can you elaborate on " Bad idea to do that automatically."
>
> In production, that has to happen automatically, isn't it? There won't be an administrator available all the time to
doa failover in case primary goes down.. 

Automatic failover is OK. Automatic failback is not OK.

>> For #3, this seems to be quite complicated. Is this possible using
>> streaming replication and if yes then how can this be achieved?
>
> Bad idea to do that automatically.


--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services

pgsql-cluster-hackers by date:

Previous
From: "Deole, Pushkar (Pushkar)"
Date:
Subject: Re: Asynchronous streaming replication in postgresql
Next
From: Radovan Jablonovsky
Date:
Subject: postgresq foreign data wrapper with foreign constrain checking, distributed (multi nodes) query execution.