Re: Archiving problem on Windows

Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230

>>> On Wed, Dec 5, 2007 at 2:47 AM, in message
<4756034B(dot)8020208(at)reynolds(dot)com(dot)au>,
Paul Lambert <paul(dot)lambert(at)reynolds(dot)com(dot)au> wrote:
> Christian Rengstl wrote:
>> show config_file points to the right one. I restarted the server
after
>> every change. After including the quotation marks as in the docs,
the
>> quotation marks also appeared in the command, so at least it shows
that
>> the config file was read.
>>
>
> How about show archive_command;? Just to verify that it's reading in
the
> right thing.
>
> e.g.
> My postgresql.conf:
> archive_command = 'copy "%p" E:\\PostgreSQL\\WAL_Archive\\%f'
>
> From pgsql:
> postgres=# show archive_command;
> archive_command
> ----------------------------------------
> copy "%p" E:\PostgreSQL\WAL_Archive\%f
>
> Cheers,
> Paul.
>
> --
> Paul Lambert
> Database Administrator
> AutoLedgers - A Reynolds & Reynolds Company
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

The archive_command is 'copy %p C:\\Archive\\DBArchive\\%f',
nevertheless I changed it to your version, but without success.