Re: PITR on Win32 - Archive and Restore - Mailing list pgsql-hackers-win32

From Andrew Dunstan
Subject Re: PITR on Win32 - Archive and Restore
Date
Msg-id 1136.24.211.141.25.1092193713.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: PITR on Win32 - Archive and Restore  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers-win32
Bruce Momjian said:
>
> OK, I have a solution.  It turns out that COPY and COPY.EXE behave
> differently.  :-O
>
>     # cat x.c
>     #include <stdio.h>
>
>     main()
>     {
>             system("copy.exe \"c:/msys/1.0/home/bruce momjian/a b\"
>     \"c:/msys/1.0/home/bruce momjian/c d\"");
>     }
>     # gcc -o x x.c
>     # ./x
>     The system cannot find the file specified.
>
> I just changed copy to copy.exe, and bingo, failure.
>
> I suggest we back out the backslash patch and provide a Win32 sample
> archive line in postgresql.conf that quotes both args, and that we add
> quotes to the Unix example too.

There is no copy.exe - it's a command builtin to cmd.exe, at least on my
system.
Before jumping to a conclusion that we have an answer we need to make sure
it works portably across all the Windows versions we are working with.

My testing and Mark's experience suggest that the source path needs to be
backslashed but the destination path maybe doesn't - which would actually
work quite well for us *with* the backslash patch.

cheers

andrew





pgsql-hackers-win32 by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: PITR on Win32 - Archive and Restore
Next
From: Bruce Momjian
Date:
Subject: Re: PITR on Win32 - Archive and Restore