Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-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

pgsql-patches by date

Next:From: Tom LaneDate: 2004-08-10 18:21:08
Subject: Re: PITR on Win32 - Archive and Restore
Previous:From: Bruce MomjianDate: 2004-08-10 18:03:32
Subject: Re: PITR on Win32 - Archive and Restore

pgsql-hackers-win32 by date

Next:From: Tom LaneDate: 2004-08-10 18:21:08
Subject: Re: PITR on Win32 - Archive and Restore
Previous:From: Bruce MomjianDate: 2004-08-10 18:03:32
Subject: Re: PITR on Win32 - Archive and Restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group