Re: PITR on Win32 - Archive and Restore

"Copy" is an internal command of the command line shell in Windows. There is
no separate executable for it.
Try "cmd.exe /C copy ...." insteads (see "cmd /?" for further options).

Regards,
Christian.

----- Original Message -----
From: <markir(at)coretech(dot)co(dot)nz>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>; "Andrew Dunstan" <andrew(at)dunslane(dot)net>;
<pgsql-hackers-win32(at)postgresql(dot)org>
Sent: Monday, August 09, 2004 7:37 AM
Subject: Re: [pgsql-hackers-win32] 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.
>
>
>
>
>
> ---------------------------(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