From: | markir(at)coretech(dot)co(dot)nz |
---|---|
To: | pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | PITR on Win32 - Archive and Restore Command Strings |
Date: | 2004-08-07 09:46:08 |
Message-ID: | 1091871968.d2133ca2f344c@mail.coretech.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 pgsql-patches |
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....
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-08-07 09:58:44 | Re: make fails if path has spaces |
Previous Message | markir | 2004-08-07 09:34:32 | Re: Eventlog |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-08-07 09:58:44 | Re: make fails if path has spaces |
Previous Message | John Hansen | 2004-08-07 07:59:39 | Re: UNICODE characters above 0x10000 |