Re: PITR on Win32 - Archive and Restore

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: PITR on Win32 - Archive and Restore
Дата
Msg-id 1136.24.211.141.25.1092193713.squirrel@www.dunslane.net
обсуждение исходный текст
Ответ на Re: PITR on Win32 - Archive and Restore  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: PITR on Win32 - Archive and Restore
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PITR on Win32 - Archive and Restore