From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | unix_socket_directory bug or feature? |
Date: | 2005-05-06 21:47:47 |
Message-ID: | 427BE603.2070409@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2005-05-06 21:53:54 | Re: unix_socket_directory bug or feature? |
Previous Message | Robert Treat | 2005-05-06 21:44:43 | Re: Views, views, views! (long) |