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 <[email protected]>:> 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.





---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match