Re: PHP's pg_connect() and non-standard location of the socket (was: REPOST: redefining location of the socket file /tmp/.s.PGSQL.5432)
От
Tom Lane
Тема
Re: PHP's pg_connect() and non-standard location of the socket (was: REPOST: redefining location of the socket file /tmp/.s.PGSQL.5432)
Дата
Msg-id
14069.992381991@sss.pgh.pa.us
Ответ на
PHP's pg_connect() and non-standard location of the socket (was: REPOST: redefining location of the socket file /tmp/.s.PGSQL.5432) (Arcady Genkin)
Список
Дерево обсуждения
Re: COPY with default values? Per-Olof Pettersson <pgsql@peope.net>
Arcady Genkin writes:
>> They're not, unless you tell them, which is why runtime setting of the
>> parameter isn't all that useful IMHO. But some people wanted it, so
>> there it is.
> Hmm... How would I tell that to `psql'? Via "-v" parameter?
IIRC, a hostname parameter that starts with '/' is now interpreted as
a socket path. So you'd do psql -h /path/to/something, or set PGHOST,
to inform the client about a nonstandard socket location.
$ psql -h /nowhere -p 7654
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running locally
and accepting connections on Unix socket '/nowhere/.s.PGSQL.7654'?
regards, tom lane
В списке pgsql-general по дате отправления