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 tounix_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 withsudo
) - Run
chown root:staff /var/pgsql_socket
(may need to be run withsudo
)