Re: PITR on Win32 - Archive and Restore

Tom Lane wrote:

>Andrew Dunstan <andrew@dunslane.net> writes:
>
>
>>Tom Lane wrote:
>>
>>
>>>As I said before, I'm willing to #ifdef the code so that the string
>>>substituted for %p converts all / to \ on Windows.  What I'd like to
>>>know is whether that's enough to solve the problems, particularly in
>>>face of spaces in the path, or whether we'll still be in quoting hell.
>>>
>>>
>
>
>
>>Names with spaces will need to be quoted :-(
>>
>>
>
>But does that have to be done in the code, or will
>    archive_command = 'copy "%p" ...'
>work?
>
>

That should work just fine (or with xcopy).

>Strictly speaking, people probably ought to use something like
>    archive_command = 'cp "%p" ...'
>on Unix too, so if this is what it takes on Windows I'm satisfied.
>Just wondering about what other gotchas Redmond has prepared for us...
>
>
>
>

Yes, it's just that Unix people (or at least those of us who are
professionals) usually have more sense that to put spaces in file names ...

cheers

andrew