Re: BUG #7514: postgres -k no longer works with spaces in the path - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7514: postgres -k no longer works with spaces in the path
Date
Msg-id 16738.1346769101@sss.pgh.pa.us
Whole thread Raw
In response to BUG #7514: postgres -k no longer works with spaces in the path  (murrayc@murrayc.com)
Responses Re: BUG #7514: postgres -k no longer works with spaces in the path  (Murray Cumming <murrayc@murrayc.com>)
List pgsql-bugs
murrayc@murrayc.com writes:
> At some point, probably in 9.1.5, the -k option to Postgres ("Unix-domain
> socket location" in --help), stopped accepting paths that contain spaces.

> For instance,
> -k '/tmp/testglom2FPDKW/path with spaces/some_postgres_data'

> It now fails with this error:
> FATAL:  invalid list syntax for "unix_socket_directories"

Ah, you're using the latest Fedora packaging of 9.1.x, which includes a
back-ported version of the unix_socket_directories change that's in
HEAD.  -k now effectively takes a list of directory names, not just
one, and it's pickier about whitespace.

IIRC, you can make it work if you put double quotes around the
space-containing name, so it'd look like this:

    -k '"/blah blah blah"'


            regards, tom lane

pgsql-bugs by date:

Previous
From: TAKATSUKA Haruka
Date:
Subject: Re: BUG #7518: "FORMAT" in the "COPY" command
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support