Re: PITR on Win32 - Archive and Restore

Tom Lane wrote:
> Bruce Momjian <[email protected]> writes:
> > OK, I think I might see the cause.  Try this:
> > 	archive_command = '""copy" "%p" "c:/databases/pgarchive/%f""'
> > In other words, quote the 'copy' command too.  Crazy --- yes.
> 
> Yikes.  If it's that hard to get it to work, maybe we should just
> knuckle under and make %p convert / to \ under Windows :-(
> 
> (Microsoft cultural imperialism wins another round...)
> 
> However, just one question --- the Microsofties also like to put spaces
> in path names.  How much quoting would be needed to make this command
> string work in the face of spaces in %p, even if we did the backslash
> thing?  If the answer is "nearly as much" then I'm not going to be
> excited about backslashing.

For sure we have to have the quoting working for spaces in directory
names.  Lets see how the new suggestion works for him.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend