Re: PITR on Win32 - Archive and Restore

Andrew Dunstan wrote:
> Bruce Momjian said:
> >
> > OK, I have a solution.  It turns out that COPY and COPY.EXE behave
> > differently.  :-O
> >
> > 	# cat x.c
> > 	#include <stdio.h>
> >
> > 	main()
> > 	{
> > 	        system("copy.exe \"c:/msys/1.0/home/bruce momjian/a b\"
> > 	\"c:/msys/1.0/home/bruce momjian/c d\"");
> > 	}
> > 	# gcc -o x x.c
> > 	# ./x
> > 	The system cannot find the file specified.
> >
> > I just changed copy to copy.exe, and bingo, failure.
> >
> > I suggest we back out the backslash patch and provide a Win32 sample
> > archive line in postgresql.conf that quotes both args, and that we add
> > quotes to the Unix example too.
> 
> There is no copy.exe - it's a command builtin to cmd.exe, at least on my
> system.
> Before jumping to a conclusion that we have an answer we need to make sure
> it works portably across all the Windows versions we are working with.
> 
> My testing and Mark's experience suggest that the source path needs to be
> backslashed but the destination path maybe doesn't - which would actually
> work quite well for us *with* the backslash patch.
> 

I saw some tests using copy.exe and thought they all did.  I see now
that was just one test.  Now that I have the setup I will try some more
combinations tomorrow.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email protected]