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@coretech.co.nz>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; "Andrew Dunstan" <andrew@dunslane.net>;
<pgsql-hackers-win32@postgresql.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@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.
>
>
>
>
>
> ---------------------------(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