Re: archive_command does not execute

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: archive_command does not execute
Дата
Msg-id 4677CBB3.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: archive_command does not execute  (Tom Arthurs <tarthurs@jobflash.com>)
Список pgsql-admin
>>> On Tue, Jun 19, 2007 at 11:16 AM, in message <46780175.3040207@jobflash.com>,
Tom Arthurs <tarthurs@jobflash.com> wrote:
>
> Looks like you are expecting the archive command to run when you shut
> down the data base. It won't.  It only runs when the xlog gets full and
> the system needs to recycle to a new logfile.

If you need to force a WAL file to test your backup process, try running
something like:

select pg_switch_xlog();

http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-BACKUP-TABLE

-Kevin




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Export/import issue/question
Следующее
От: "Bill Willits"
Дата:
Сообщение: reindex in v8.2