From: | "Deole, Pushkar (Pushkar)" <pdeole(at)avaya(dot)com> |
---|---|
To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
Cc: | "pgsql-cluster-hackers(at)postgresql(dot)org" <pgsql-cluster-hackers(at)postgresql(dot)org> |
Subject: | Re: Asynchronous streaming replication in postgresql |
Date: | 2015-03-13 10:28:25 |
Message-ID: | 78A4D6BFBAA5BA49A5E94DA00A6A76E3535640@AZ-FFEXMB04.global.avaya.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cluster-hackers |
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 do a failover in case primary goes down..
-----Original Message-----
From: Simon Riggs [mailto:simon(at)2ndQuadrant(dot)com]
Sent: Friday, March 13, 2015 3:23 PM
To: Deole, Pushkar (Pushkar)
Cc: pgsql-cluster-hackers(at)postgresql(dot)org
Subject: Re: [pgsql-cluster-hackers] Asynchronous streaming replication in postgresql
On 12 March 2015 at 05:56, Deole, Pushkar (Pushkar) <pdeole(at)avaya(dot)com> wrote:
> I am new to postgreSql and evaluating the streaming replication for my
> use case. My use case is:
>
>
>
> 1. Need to replicate data from primary database (master) to secondary
> database (slave) asynchronously.
>
> 2. If master goes down, the slave should automatically be promoted to
> master.
>
> 3. Later, when the original primary server (original master) is
> brought up again, it should obtain back its master role and the new
> master should assume the slave again as it was with original setup.
>
>
>
> For #1, the streaming replication of postgresql is good enough.
>
> For #2, we need to create the trigger file in slave. This can be done
> manually. How can we do this automatically?
Look at repmgr, it does what you need.
> 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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com_&d=AwIBaQ&c=BFpWQw8bsuKpl1SgiZH64Q&r=9JxdEvGq7qy3NnL3UxN47w&m=40Wa40JcHBzcpMHkes_PqVNhpVzn4pK5rDc4JEb1XcI&s=BTCgqd3RbpTPwz5yzUOwfvuP0p1OkgnFGfKcfF6BeDU&e=
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2015-03-13 11:03:21 | Re: Asynchronous streaming replication in postgresql |
Previous Message | Simon Riggs | 2015-03-13 09:52:56 | Re: Asynchronous streaming replication in postgresql |