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: 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-10 18:11:51
Message-ID: 120.1092161511@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:
> I have gotten confused by this. Does COPY work with quoted paths only
> if we use forward slashes, or was this fix just for the slash issue and
> not spaces?

This only fixes the slash issue. If your database path includes spaces
you'll still need to put quotes in the archive_command, but it shouldn't
be any worse than
archive_command = 'copy "%p" "c:\someplace\%f"'

I'd appreciate confirmation though from some win32 users that the above
indeed works.

regards, tom lane

In response to

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Tom Lane 2004-08-10 18:21:08 Re: PITR on Win32 - Archive and Restore
Previous Message Bruce Momjian 2004-08-10 18:03:32 Re: PITR on Win32 - Archive and Restore

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-08-10 18:21:08 Re: PITR on Win32 - Archive and Restore
Previous Message Bruce Momjian 2004-08-10 18:03:32 Re: PITR on Win32 - Archive and Restore