From: | Szűcs Gábor <surrano(at)mailbox(dot)hu> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | unix_socket_directory not fully recognized by pg_ctl? |
Date: | 2003-11-16 21:01:35 |
Message-ID: | 001e01c3ac84$e19c8e20$1004a8c0@priscilla |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Gurus,
I have a similar problem as discussed in
http://archives.postgresql.org/pgsql-novice/2003-06/msg00321.php
This probably should go to pgsql-novice too, but I'm not a member of that
list so please forgive my lazyness.
I use Debian Woody Linux and installed postgres (v7.2.1), but I needed a
newer version, so decided to try 7.4RC2 (which is not in the news yet, as I
checked today). It compiled and installed, and I could run the backend.
However, PHP could not run, since it searched for the socket in
/var/run/postgresql.
I found the unix_socket_directory option in postgresql.conf and set it to
/var/run/postgresql and restarted the server with
bin/pg_ctl start -w -D data -l data/postgres.log
The socket file and socket lockfile was created in /var/run/postgresql
-- it's ok, but pg_ctl hung, and after quite some time it exited with
"pg_ctl: postmaster does not start"
However; I can connect the server with PHP's pg_connect(), or psql -- but
psql only works through TCP/IP (i.e. -h localhost). If run locally, it
searches for socket in /tmp. Using
psql -h /var/run/postgresql
did work. My questions are:
What causes pg_ctl's strange behaviour?
Is this the only way to tell this to psql?
Is there a compile-time configuration parameter? (could not find it)
Is there a psqlrc setting for this?
Is there a complete description for psqlrc? (could not find it)
TIA,
--------------------- cut here ---------------------
G.
--
while (!asleep) sheep++;
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-11-16 22:22:35 | Re: Conservation of OIDs |
Previous Message | Martin Marques | 2003-11-16 20:36:55 | Re: Error on initdb with 7.4RC2 |