Re: PITR on Win32 - Archive and Restore

Andrew Dunstan <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
I wrote:

>
> I will install MSys and friends on my new Windows machine and play 
> around to see what works, unless someone comes up with a tested 
> solution first.
>
>

Experimentation shows that xcopy is just as braindead about slashes as 
copy is. But quoting the paths with backslashes worked, e.g.

system("xcopy \"c:\\foo bar\\baz\" \"c:\\tmp\" /y >nul");

So it appears that we need either to have the paths output with 
system-dependant slashes, or, perhaps more flexibly, a new escape 
sequences (%P?) which does system-dependent slashes - that would be a 
small addition to src/backend/access/transam/xlog.c

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.