PITR on Win32 - Archive and Restore Command Strings

Given that I was doing a bit of testing on win32 anyway, I just couldn't help
myself...

There is a bit of a trap if using '%p' in archive_command - it has seperators
like '/' instead of '\', so does not work for some windows commands (like
'copy' for instance).

I had to put in the complete path for pg_xlog, e.g:

archive_command = 'copy c:\\databases\\pgdata\\pg_xlog\\%f
c:\\databases\\pgarchive\\%f'

and similarly during recovery, e.g:

restore_command = 'copy c:\\databases\\pgarchive\\%f
c:\\databases\\pgdata\\pg_xlog\\%f'


Is there a format that is equivalent to '%p' but outputs a windows style path?

regards

Mark

P.S : PITR itself worked perfectly, rolling forward 106 logs....


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend