Re: Fwd: 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 Tue, Dec 4, 2007 at 11:44 AM, in message
<20071204104435.GE25044@a-kretschmer.de>, "A. Kretschmer"
<andreas.kretschmer@schollglas.com> wrote:
> am  Tue, dem 04.12.2007, um 11:31:41 +0100 mailte Christian Rengstl
> folgendes:
>> 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
>
> 2 questions:
>
> 1. really 'myfile', or is 'myfile' only a placeholder for the real
> logfile?
>
> 2. please try to specify the full path for the source file, maybe
the
> copy- command can't found the file without the full path.
>
>
> Hope that helps, and please no top- posting. (in german: TOFU)
>
>
> Andreas

1) myfile is just a placeholder, as I am currently not working on the
server directly and i can't copy the filename using vnc...
2) the path given, is the path postgresql obviously interprets my
archive_command, so i don't know how to specify it.