Re: archive_command - Mailing list pgsql-general

From Fujii Masao
Subject Re: archive_command
Date
Msg-id AANLkTilZ1J7EPoq5z_9uC-50vKKUg8u1MJFoS5Dk-gh6@mail.gmail.com
Whole thread Raw
In response to Re: archive_command  (Jun Wang <junw2000@gmail.com>)
List 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 by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Disable executing external commands from psql?
Next
From: Stephen Frost
Date:
Subject: Re: Disable executing external commands from psql?