Restore master from slave

Поиск
Список
Период
Сортировка
От sonnix
Тема Restore master from slave
Дата
Msg-id 1306525607517-4433255.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Restore master from slave
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: COMMIT takes long time for read only transaction
Следующее
От: "M. D."
Дата:
Сообщение: library problem with psql