RE: Resync second slave to new master

From: Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au>
To: Michael Paquier <michael(at)paquier(dot)xyz>, Yavuz Selim Sertoğlu <yavuzselimsertoglu(at)gmail(dot)com>
Cc: pgsql-generallists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Resync second slave to new master
Date: 2018-03-08 10:38:30
Message-ID: 1c277a2319f8447b8264d4c83bba4821@ITUPW-EXMBOX3B.UniNet.unisa.edu.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks! That fixed the issue.

-----Original Message-----
From: Michael Paquier [mailto:michael(at)paquier(dot)xyz]
Sent: Thursday, 8 March 2018 6:41 PM
To: Yavuz Selim Sertoğlu <yavuzselimsertoglu(at)gmail(dot)com>
Cc: Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au>; pgsql-generallists.postgresql.org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Resync second slave to new master

On Thu, Mar 08, 2018 at 10:48:29AM +0300, Yavuz Selim Sertoğlu wrote:
> If not set, could you add recovery.conf file
> recovery_target_timeline='latest'
> parameter?
> https://www.postgresql.org/docs/devel/static/recovery-target-settings.html

Yes, that's visibly the issue here.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Łukasz Jarych 2018-03-08 12:26:55 Command to execute SQL string
Previous Message Alexandru Lazarev 2018-03-08 09:49:33 What is the meaning of pg_restore output?