Disable unix-domain sockets?

From: Murray Cumming <murrayc(at)murrayc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Disable unix-domain sockets?
Date: 2012-10-25 11:40:43
Message-ID: 1351165243.496.20.camel@murayc-x220.fritz.box
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to avoid having to specify the unix socket directory when
starting local instances of postgres, due to the new restrictions on the
characters that can be in its path
http://archives.postgresql.org/pgsql-bugs/2012-09/msg00012.php
(only partly solved by a recent commit):

This needs to be specified with the -k command line parameter:
http://www.postgresql.org/docs/9.2/static/app-postgres.html
or the unix_socket_directory configuration setting:
http://www.postgresql.org/docs/9.2/static/runtime-config-connection.html#GUC-UNIX-SOCKET-DIRECTORY
where it is documented as being for unix-domain socket connections.

I hoped that if I didn't use "local" in my pg_hba.conf file, instead
using just "host", then postgresql might not allow unix socket
connections at all, so it wouldn't need to create that .lock file.
http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html

But postgres still tries to create the .lock file, failing here on
Fedora because it defaults not to /tmp but to /var/run/postgresql, which
the local user can't write to.

So is there some way to avoid the need for the .lock file, or should the
documentation say that the directory is needed regardless of the
connections allowed?

And if not, is there any downside to just using /tmp ?

--
murrayc(at)murrayc(dot)com
www.murrayc.com
www.openismus.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Heiko Wundram 2012-10-25 11:52:09 Re: Somewhat automated method of cleaning table of corrupt records for pg_dump
Previous Message Thomas Boussekey 2012-10-25 10:47:17 Re: Data sets for download