Re: Archiving problem on Windows - Mailing list pgsql-general

From Christian Rengstl
Subject Re: Archiving problem on Windows
Date
Msg-id 475667B4.90AD.0080.0@klinik.uni-regensburg.de
Whole thread Raw
In response to Re: Archiving problem on Windows  (Paul Lambert <paul.lambert@reynolds.com.au>)
List pgsql-general


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 <paul.lambert@reynolds.com.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.


pgsql-general by date:

Previous
From: "Christian Rengstl"
Date:
Subject: Re: Archiving problem on Windows
Next
From: "Peter Childs"
Date:
Subject: Re: Server crashed and now experiencing slow running queries