Restore master from slave

From: sonnix <sonnix(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Restore master from slave
Date: 2011-05-27 19:46:47
Message-ID: 1306525607517-4433255.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M. D. 2011-05-28 06:37:08 library problem with psql
Previous Message Tom Lane 2011-05-27 18:34:10 Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum