unix_socket_directory not fully recognized by pg_ctl?

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++;

Responses

Browse pgsql-general by date

  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