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 8:25 AM, in message
<4756527B(dot)6040609(at)reynolds(dot)com(dot)au>,
Paul Lambert <paul(dot)lambert(at)reynolds(dot)com(dot)au> wrote:
> Christian Rengstl wrote:
>> The archive_command is 'copy %p C:\\Archive\\DBArchive\\%f',
>> nevertheless I changed it to your version, but without success.
>>
>>
>> ---------------------------(end of
broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
>>
>>
>
> And what does pgsql show when you do a "show archive_command;"
>
> --
> Paul Lambert
> Database Administrator
> AutoLedgers - A Reynolds & Reynolds Company
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do
not
> match

Now i did the following: I changed "copy" to "xcopy" then all of a
sudden I received the error message that a file could not be found. Then
I copied one existing file and changed the name so that it's in the
pg_xlog directory, but since then I do not receive any messages in the
log file or in the windows event logs and no file is copied either.