Re: BUG #3439: pg_standby and path name with space - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #3439: pg_standby and path name with space
Date
Msg-id 20070716084114.GD26466@svr2.hagander.net
Whole thread Raw
In response to Re: BUG #3439: pg_standby and path name with space  (Magnus Hagander <magnus@hagander.net>)
List pgsql-bugs
On Fri, Jul 13, 2007 at 10:50:16AM +0200, Magnus Hagander wrote:
> On Fri, Jul 13, 2007 at 09:29:59AM +0100, Simon Riggs wrote:
> > On Thu, 2007-07-12 at 19:36 +0000, ISHIDA Akio wrote:
> > > The following bug has been logged online:
> > >
> > > Bug reference:      3439
> > > Operating system:   Windows XP
> > > Description:        pg_standby and path name with space
> > > Details:
> > >
> > > pg_standby failed if path name containing spaces.
> > >
> > > C:\Documents and Settings\ishida\pgsql>pg_standby -d "C:\Documents and
> > > Settings\ ishida\pgsql\archive_dir" 000000010000000000000000 data\pg_xlog
> > >
> > > Trigger file            : <not set>
> > > Waiting for WAL file    : C:\Documents and
> > > Settings\ishida\pgsql\archive_dir\000000010000000000000000
> > > WAL file path           : 000000010000000000000000
> > > Restoring to...         : data\pg_xlog
> > > Sleep interval          : 5 seconds
> > > Max wait interval       : 0 forever
> > > Command for restore     : copy C:\Documents and
> > > Settings\ishida\pgsql\archive_dir\000000010000000000000000 data\pg_xlog
> > > Num archived files kept : all files
> > > running restore         :The system cannot find the file specified.
> > > The system cannot find the file specified.
> > > The system cannot find the file specified.
> > > not restored            :
> >
> > Magnus,
> >
> > Looks to me like the following patch would fix the reported issue on
> > Windows:
>
> Is this actually a Windows issue? Doesn't the same problem show up on Unix
> if you have a space in the path? (It's a lot more common on Windows, but
> it'spossible on Unix as well).
>
> It does seem that the fix should work on Unix as well though, but just to
> we label the thing correctly.

My own very trivial checks shows it should, so I've applied this patch.

Thanks!

//Magnus

pgsql-bugs by date:

Previous
From: "Devinder Singh"
Date:
Subject: Re: BUG #3439: pg_standby and path name with space
Next
From: "ITAGAKI Takahiro"
Date:
Subject: BUG #3453: Error on COPY TO/FROM 'non-ascii-path'