Re: PITR on Win32 - Archive and Restore

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(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:15:47
Message-ID: 200408090315.i793Fl608137@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-patches

Tom Lane wrote:
> 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.

For sure we have to have the quoting working for spaces in directory
names. Lets see how the new suggestion works for him.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Mark Kirkwood 2004-08-09 03:37:50 Re: PITR on Win32 - Archive and Restore
Previous Message Tom Lane 2004-08-09 03:13:49 Re: PITR on Win32 - Archive and Restore

Browse pgsql-patches by date

  From Date Subject
Next Message Mark Kirkwood 2004-08-09 03:37:50 Re: PITR on Win32 - Archive and Restore
Previous Message Tom Lane 2004-08-09 03:13:49 Re: PITR on Win32 - Archive and Restore