When I login as user postgres, I can copy the files without any
problem.
Here is the error message (translated as it appears in German in my log
files):
>>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code
1
>>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code
1
>>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code
1
WARNING: transaction log file could not be archived: too many errors
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 Mon, Dec 3, 2007 at 11:27 PM, in message
<475482CB.9090701@xxxxxxxxxxxxxxx>,
Paul Lambert <paul.lambert@xxxxxxxxxxxxxxx> wrote:
> Christian Rengstl wrote:
>> Hi list,
>>
>> a have a problem using the following archiving command on windows:
>> 'copy %p C:\\Archive\\DBArchive\\%f'
>> The error message i get is saying that the file could not be copied
>> because of error code 1. The strange thing is that in the archive
>> directory there are files that were copied one or two weeks ago and
>> since then i have not change the command.
>>
>> Thanks for any advice!
>>
>>
>
> It would help to paste the actual error message, not your description
of
> the error message.
>
> Have you checked that the postgres user has full control over the
> DBArchive directory and that there is available space on the disk?
>
> --
> 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
