Contents

unix_socket_directories

A configuration parameter specifying the file system directories for Unix domain sockets

unix_socket_directories is a configuration parameter specifying the file system directories for the PostgreSQL server to store its Unix domain sockets.

unix_socket_directories was added in PostgreSQL 9.3, replacing unix_socket_directory.

Default value

The default value for unix_socket_directories is: /tmp.

Change history

Examples

From an rpm installation running under Fedora32]:

postgres=# SHOW unix_socket_directories;
  unix_socket_directories  
---------------------------
 /var/run/postgresql, /tmp
(1 row)

Directory contents:

[postgres@fedora32 ~]$ ls -la /var/run/postgresql
total 4
drwxr-xr-x.  2 postgres postgres  80 Oct 23 04:51 .
drwxr-xr-x. 25 root     root     660 Oct 21 14:08 ..
srwxrwxrwx.  1 postgres postgres   0 Oct 23 04:51 .s.PGSQL.5432
-rw-------.  1 postgres postgres  65 Oct 23 04:51 .s.PGSQL.5432.lock

[postgres@fedora32 ~]$ ls -la /tmp/.s.PGSQL.5432*
srwxrwxrwx. 1 postgres postgres  0 Oct 23 04:51 /tmp/.s.PGSQL.5432
-rw-------. 1 postgres postgres 50 Oct 23 04:51 /tmp/.s.PGSQL.5432.lock

Categories

GUC configuration item