Search Postgresql Archives

RE: Missing WAL file after running pg_rewind

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.paquier@xxxxxxxxx] 
Sent: Saturday, 13 January 2018 9:04 PM
To: Dylan Luong <Dylan.Luong@xxxxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux