Re: pg_ctl problem - Mailing list pgsql-general

From jseymour@LinxNet.com (Jim Seymour)
Subject Re: pg_ctl problem
Date
Msg-id 20040409002351.0E1F54307@jimsun.LinxNet.com
Whole thread Raw
In response to Re: pg_ctl problem  (Alexander Cohen <alex@toomuchspace.com>)
Responses Re: pg_ctl problem
Re: pg_ctl problem
List pgsql-general
Alexander Cohen <alex@toomuchspace.com> wrote:
>
[snip]
> >                                                             Why not
> > just get rid of the space and save yourself the current, and possibly
> > future, grief?
>
> because this is an app for users and they might have spaces in their
> path.

*Users* are starting up postmaster?  *shrug*  ISTM you're left with the
following choices:

    1. Work at it until you've figured-out just the right
       combination of shell escapes to get the path though pg_ctl's
       "cooking."  The prior caveat applies: If pg_ctl is modified
       relative to that switch's argument handling, it'll break again.

    2. Modify pg_ctl so the argument, in all its processing, is
       preserved with embedded spaces.  Of course, the next release of
       pgsql would require re-doing it if pg_ctl is changed.

    3. Talk pgsql's developers into fixing the "problem."
       (If you fix it, as in #2, you could submit a patch.)

    4. Tell your users not to do that.  Spaces in pathnames are
       pure evil anyway.  A problem generally only found with end-users
       using (only) point-n-drool tools.

Personally, looking at pg_ctl's code, I think #1 is exceedingly
unlikely to succeed.  #2 (and, by extension, #3) looks kind of
iffy, too.

Good luck.

--
Jim Seymour                | Spammers sue anti-spammers:
jseymour@LinxNet.com       |     http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com  | Please donate to the SpamCon Legal Fund:
                           |     http://www.spamcon.org/legalfund/

pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Select/Group by/Order by question
Next
From: Alexander Cohen
Date:
Subject: Re: pg_ctl problem