Re: PITR on Win32 - Archive and Restore
Bruce Momjian <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
[email protected] wrote: > Using : > > archive_command = '"copy "%p" "c:/databases/pgarchive/%f""' > > I see this is the log: > > LOG: archive command ""copy > "c:/databases/pgdata/pg_xlog/000000010000000000000000" > "c:/databases/pgarchive/000000010000000000000000""" failed: return code 1 > The system cannot find the file specified. > > Looks like it is confused about what the executable is... 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. -- 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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [email protected])