Re: PITR on Win32 - Archive and Restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: markir(at)coretech(dot)co(dot)nz, Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: PITR on Win32 - Archive and Restore
Date: 2004-08-09 03:13:49
Message-ID: 4430.1092021229@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> 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

In response to

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Bruce Momjian 2004-08-09 03:15:47 Re: PITR on Win32 - Archive and Restore
Previous Message Bruce Momjian 2004-08-09 02:23:00 Re: PITR on Win32 - Archive and Restore

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-08-09 03:15:47 Re: PITR on Win32 - Archive and Restore
Previous Message Bruce Momjian 2004-08-09 02:23:00 Re: PITR on Win32 - Archive and Restore