Hello,
unix_socket_direct = '/tmp/foo'
unix_socket_group = 'postgres'
unix_socket_permission = '0200'
-bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc/ start
postmaster starting
-bash-3.00$ LOG: could not open Ident usermap file
"/usr/local/pgsql/etc/pg_ident.conf": No such file or directory
LOG: database system was shut down at 2005-05-06 14:46:39 PDT
LOG: checkpoint record is at 0/A32BD4
LOG: redo record is at 0/A32BD4; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 545; next OID: 17230
LOG: database system is ready
-bash-3.00$ bin/psql -U postgres template1
psql: could not connect to server: No such file or directory Is the server running locally and accepting
connectionson Unix domain socket "/tmp/.s.PGSQL.5432"?
-bash-3.00$
psql is looking in the wrong directory for the socket.
-bash-3.00$ bin/psql -U postgres -h 127.0.0.1 template1
Welcome to psql 8.0.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands
\gor terminate with semicolon to execute query \q to quit
template1=#
Sincerely,
Joshua D. Drake
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/