Re: PITR on Win32 - Archive and Restore

Well, it is really fighting us.....

This is the archive_command:

'""copy.exe" "%p" "c:/databases/pgarchive/%f""'

and this is the log:

LOG: archive command """copy.exe"
"c:/databases/pgdata/pg_xlog/000000010000000000000007"
"c:/databases/pgarchive/000000010000000000000007""" failed: return code 1
'"copy.exe"' is not recognized as an internal or external command,
operable program or batch file.

(tried plain old '"copy"' too)

regards

Mark

Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>:> Tom Lane wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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.