These are instructions to setup Postgres.app to allow connections over unix sockets. These instructions were written for Mac OS X 10.8 (Mountain Lion).
- Run Postgres.app once so that the configuration is initialized in
~/Library/Application Support/Postgres
.
- Close Postgres.app
- Open
~/Library/Application Support/Postgres/var/postgresql.conf
in your favorite text editor.
- Uncomment the line
unix_socket_directory = ''
and change it to unix_socket_directory = '/var/pgsql_socket'
- Create the directory
/var/pgsql_socket
if it doesn't exist.
- Run
chmod 770 /var/pgsql_socket
(may need to be run with sudo
)
- Run
chown root:staff /var/pgsql_socket
(may need to be run with sudo
)