The content of the history file 00000006.history is: $ more 00000006.history 1 2CE/8A000098 no recovery target specified 2 2CE/FF974EF0 no recovery target specified 3 2CF/51000098 no recovery target specified 4 2D1/C90ACD88 no recovery target specified 5 383/C0790E50 no recovery target specified
Here are the last few archive file of the old timeline (old master): 0000000500000383000000BD 0000000500000383000000BE 0000000500000383000000BF 0000000500000383000000C0 0000000500000383000000C1 Here are the first few archive files of the new timeline (new master): 0000000500000383000000C0.partial 0000000600000383000000C0 0000000600000383000000C1 0000000600000383000000C2 0000000600000383000000C3 Looks like it has folked at C0. But why is the new slave asking for 0000000600000383000000BE on timeline during the restore after the pg_rewind? And not from C0? Dylan -----Original Message----- From: Michael Paquier [mailto:michael.paqu...@gmail.com] Sent: Saturday, 13 January 2018 9:04 PM To: Dylan Luong <dylan.lu...@unisa.edu.au> Cc: pgsql-general@lists.postgresql.org Subject: Re: Missing WAL file after running pg_rewind On Fri, Jan 12, 2018 at 09:44:25PM +0000, Dylan Luong wrote: > The file exist in the archive directory of the old master but it is > for the previous timeline, ie 5 and not 6, ie > 0000000500000383000000BE. Can I just rename the file to 6 timeline? Ie > 0000000600000383000000BE What are the contents of the history file for this new timeline? You are looking at 00000006.history which should be archived as well. You could do that assuming that WAL has forked on this segment at promotion as both segments would have the same contents up to the point where WAL has forked. -- Michael
