Re: archive_command

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: archive_command
Дата
Msg-id AANLkTilZ1J7EPoq5z_9uC-50vKKUg8u1MJFoS5Dk-gh6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: archive_command  (Jun Wang <junw2000@gmail.com>)
Список pgsql-general
On Wed, Jun 2, 2010 at 3:47 AM, Jun Wang <junw2000@gmail.com> wrote:
> The document recommends a command as below:
>
> archive_command = 'test ! -f /var/lib/pgsql/backup_in_progress || cp
> -i %p /var/lib/pgsql/archive/%f < /dev/null'
>
> How can this be done using windows batch? I tried the following
> command, but it did not work:
>
> archive_command = 'if not exist C:\\pgsql\\backup_in_progress || copy
> %p C:\\pgsqlarchive\\%f'

You want to take "standalone hot backup" instead of normal one? If not,
you don't need to check the file "backup_in_progress".

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

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

Предыдущее
От: Ken Tanzer
Дата:
Сообщение: Re: Disable executing external commands from psql?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Disable executing external commands from psql?