Re: PITR on Win32 - Archive and Restore

Andrew Dunstan <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>

Tom Lane wrote:

>Andrew Dunstan <[email protected]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.