A yoda look alike informed me that I should use -h which does work.
Joshua D. Drake wrote:
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 8: explain analyze is your friend
