From: sonnix <sonnix@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Restore master from slave
Date: Fri, 27 May 2011 12:46:47 -0700 (PDT)
Message-ID: <1306525607517-4433255.post@n5.nabble.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sonnix@gmail.com
Subject: Re: Restore master from slave
In-Reply-To: <1306525607517-4433255.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox