pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestore master from slave
2+ messages / 2 participants
[nested] [flat]
* Restore master from slave
@ 2011-05-27 19:46 sonnix <sonnix@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: sonnix @ 2011-05-27 19:46 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Restore master from slave
@ 2011-05-31 13:45 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: sonnix <sonnix@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2011-05-31 13:45 UTC (permalink / raw)
To: sonnix <sonnix@gmail.com>; pgsql-admin
sonnix <sonnix@gmail.com> wrote:
> Can i make only base backup from temporary master to main master?
You didn't say which version of PostgreSQL you're using, what OS
it's running on, how you're managing the replication, or what
exactly you did -- so it's hard to give very specific advice. That
said, I'm pretty sure that the answer to the above question is that
when you promote a standby to be the new master, you must do a base
backup from it to anything to which you want to replicate
transactions from the new master -- including the old master. If
you have rsync available, you can probably do this very quickly if
you use the right options.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-05-31 13:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-27 19:46 Restore master from slave sonnix <sonnix@gmail.com>
2011-05-31 13:45 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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