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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: murrayc(at)murrayc(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7514: postgres -k no longer works with spaces in the path
Date: 2012-09-04 14:31:41
Message-ID: 16738.1346769101@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

murrayc(at)murrayc(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2012-09-04 17:11:53 Re: BUG #6528: pglesslog still referenced in docs, but no 9.1 support
Previous Message lokendra.dixit 2012-09-04 12:19:22 BUG #7519: incresed data base size and query performance lost