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.6040609@reynolds.com.au>,
Paul Lambert  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.