Re: PITR on Win32 - Archive and Restore

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> 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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073