postgresql history and timelines

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

 



Hi guys,
Wanted to understand something that isnt clear to me, please correct me if I'm wrong :

-When we want to recover our database or promote a secondary to be a master a new time line will be created. A new file will be created in the pg_xlog directory named '00000TIMELINEID.history'.
-During the daily work, the primary or the secondary shouldnt have a .history file right ?
-The history file contains only the timeline id and the location to start from the timeline.
-When using repmgr, after cloning the primary and starting the secondary the secondary should replay wals from :
1.archives
2.local wals
3.Streaming replication from primary  
?

I cloned the primary to the secondary, and when I tried to start the secondary I got the next message : 
 LOG:  restored log file "000000010000090A00000002" from archive
FATAL:  requested timeline 2 is not a child of this server's history
 DETAIL:  Latest checkpoint is at xx on timeline 1, but in the history of the requested timeline, the server forked off from that timeline at YY.

So I didnt recover my primary or promoted a secondary so how is it possible that I have a file from timeline 2 ? Are there other operations that creates a new timeline ?


Thanks.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux