Re: [GENERAL] Lag in asynchronous replication

Hi Michael, Are you asking to have slave with synchronous replication? Regards, SUBHANKAR CHATTOPADHYAY On 24 Mar 2017 09:33, "Michael Paquier" wrote: > On Thu, Mar 23, 2017 at 11:37 PM, Subhankar Chattopadhyay > wrote: > > in case of automated failover i want to che

[GENERAL] Lag in asynchronous replication

hi, in case of automated failover i want to check if slave ia lagging​ from master and only if it is in sync, i want to do failover. But I am working in a virtual cloud environment so by that time the master VM may not be available to me. How can i check the lag in that case ? Regards, SUBHANKAR

Re: [GENERAL] pgbasebackup necessary for master slave change?

pg_rewind cannot be used as I am on 9.4. Anything else? On Thu, Dec 8, 2016 at 3:23 PM, Achilleas Mantzios wrote: > On 08/12/2016 11:33, Subhankar Chattopadhyay wrote: >> >> Hi, >> >> Few days back I had asked if it is needed to to pg_basebackup for >> e

Re: [GENERAL] pgbasebackup necessary for master slave change?

I am on 9.4. Doesn't look like we have it available on 9.4. Do we have any other option? On Thu, Dec 8, 2016 at 3:15 PM, Chris Travers wrote: > > > On Thu, Dec 8, 2016 at 10:33 AM, Subhankar Chattopadhyay > wrote: >> >> Hi, >> >> Few days back I had

[GENERAL] pgbasebackup necessary for master slave change?

e new master without having to do full backup? Subhankar Chattopadhyay Bangalore, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_basebackup on slave running for a long time

Thanks John, Well that clarifies about archive a lot! On 22 Nov 2016 22:22, "John R Pierce" wrote: On 11/22/2016 3:41 AM, Subhankar Chattopadhyay wrote: > John, > > Can you explain the Wal Archive procedure, how it can be setup so that > the slave never goes out of sync,

Re: [GENERAL] pg_basebackup on slave running for a long time

John, Can you explain the Wal Archive procedure, how it can be setup so that the slave never goes out of sync, even if master deletes the WAL files? On Tue, Nov 22, 2016 at 4:04 PM, Subhankar Chattopadhyay wrote: > So, the question here is while I apply update on Slave, how do I know > if

Re: [GENERAL] pg_basebackup on slave running for a long time

help. Can anybody help in here? On Mon, Nov 21, 2016 at 12:40 PM, John R Pierce wrote: > On 11/20/2016 11:00 PM, Subhankar Chattopadhyay wrote: > > Yes so if the slave is behind I need to start over pgbasebackup. I saw > according to the documentation this query gives us the replica

Re: [GENERAL] pg_basebackup on slave running for a long time

> On 11/20/2016 10:37 PM, Subhankar Chattopadhyay wrote: > >> We are using the database in a cloud setup and the nodes are running >> in VMs. The slave can fall behind for various reasons as you have >> stated, like slave is shut down or high write workload. >>

Re: [GENERAL] pg_basebackup on slave running for a long time

ce wrote: > On 11/20/2016 10:00 PM, Subhankar Chattopadhyay wrote: >> >> Thanks for reply. In situations where slave is behind master, if I >> don't start over, will it catch up automatically? >> I am using 9.4 version. > > > it should stay within a few sec

Re: [GENERAL] pg_basebackup on slave running for a long time

Hi John, Thanks for reply. In situations where slave is behind master, if I don't start over, will it catch up automatically? I am using 9.4 version. On Mon, Nov 21, 2016 at 11:22 AM, John R Pierce wrote: > On 11/20/2016 9:29 PM, Subhankar Chattopadhyay wrote: >> >> We h

[GENERAL] pg_basebackup on slave running for a long time

somebody throw some light on this? Subhankar Chattopadhyay Bangalore, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general