Re: Streaming replication, master recycling - Mailing list pgsql-general

From Venkata Balaji N
Subject Re: Streaming replication, master recycling
Date
Msg-id CAEyp7J-P+E1i24g6TnDNj=ib9yENS+XP-pTs2v3aNM-TmSjodQ@mail.gmail.com
Whole thread Raw
In response to Streaming replication, master recycling  (<fredrik@huitfeldt.com>)
Responses Re: Streaming replication, master recycling
List pgsql-general

On Wed, May 11, 2016 at 2:31 PM, <fredrik@huitfeldt.com> wrote:
Hi All,

we are currently using streaming replication on multiple node pairs. We are seeing some issues, but I am mainly interrested in clarification.

When a failover occurs, we touch the trigger file, promoting the previous slave to master. That works perfectly.

For recycling the previous master, we create a recovery.conf (with recovery_target_timeline = 'latest') and *try* to start up. If postgresql starts up, we accept it as a new slave. If it does not, we proceed with a full basebackup.

Which version of postgresql you are using ?

You need to shutdown master first, then promote slave and then other way round, but, this can be clarified only if you let us know the postgresql version. This is quite tricky in 9.2.x and from 9.3.x.

Regards,
Venkata B N

Fujitsu Australia

pgsql-general by date:

Previous
From: martin.kamp.jensen@schneider-electric.com
Date:
Subject: Re: Invalid data read from synchronously replicated hot standby
Next
From:
Date:
Subject: Re: Streaming replication, master recycling