Re: WAL files backup

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: WAL files backup
Дата
Msg-id 20070216031021.GF4682@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: WAL files backup  (pedro noticioso <cucnews@yahoo.com>)
Список pgsql-admin
pedro noticioso wrote:

> regresamos wal files a pg_xlog - COPY BACKED UP WAL
> FILES BACK TO pg_xlog DIRECTORY

This step is wrong.  You don't have to manually put the pg_xlog files in
the pg_xlog directory -- you have to let the recovery_command copy them
back from the archive area.  Note that recovery.conf does not go into
the share/ directory, but in data/.  And it must be present _only_ when
you want the system to attempt the recovery, not before.

Also I didn't see any pg_start_backup() nor pg_stop_backup() calls in
your procedure.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

В списке pgsql-admin по дате отправления:

Предыдущее
От: pedro noticioso
Дата:
Сообщение: Re: WAL files backup
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WAL files backup