Restore master from slave - Mailing list pgsql-admin

From sonnix
Subject Restore master from slave
Date
Msg-id 1306525607517-4433255.post@n5.nabble.com
Whole thread Raw
Responses Re: Restore master from slave  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: COMMIT takes long time for read only transaction
Next
From: "M. D."
Date:
Subject: library problem with psql