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
        connections on 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
       \g or 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/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to