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@candle.pha.pa.us>:> 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.
