Re: PITR on Win32 - Archive and Restore

Tom Lane <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
Bruce Momjian <[email protected]> writes:
> 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.

Yikes.  If it's that hard to get it to work, maybe we should just
knuckle under and make %p convert / to \ under Windows :-(

(Microsoft cultural imperialism wins another round...)

However, just one question --- the Microsofties also like to put spaces
in path names.  How much quoting would be needed to make this command
string work in the face of spaces in %p, even if we did the backslash
thing?  If the answer is "nearly as much" then I'm not going to be
excited about backslashing.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
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.