Restore master from slave

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

 



Hi,
i have master and slave server(timeline 1). I turned off master and set up
slave to new temporary master and it has enabled wal archiving (timeline 2).
While the main master was turned off i had some insert to temporary master.
I need to recovery this inserts to main master from wal logs. When i made
recovery it create new timeline 3, but inserts from temporary master didn't
executed

restored log file "000000010000000000000006" from archive
consistent recovery state reached at 0/6017F08
record with zero length at 0/6017F08
redo is not required
restored log file "00000002.history" from archive
cp: cannot stat `/mnt/backup/backup/archive/00000003.history': No such file
or directory
selected new timeline ID: 3


Can i make only base backup from temporary master to main master?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Restore-master-from-slave-tp4433255p4433255.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[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