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
- PostgreSQL 9.3
- added (c9b0cbe9)
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
References
- PostgreSQL documentation: unix_socket_directories