Re: psql inability to select a socket

> AFAIK there's a special case for "hostnames" with slashes; those get
> interpreted as a path to a local socket. Try setting PGHOST to
> /var/www/tmp before you start psql, for instance.

Ah! Jeroen this is wonderful. Thank you.

stink# setenv PGHOST /var/www/tmp
stink# /var/postgresql/bin/psql -U snort snort
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

snort=>

My mistake, I didn't RT the FM:

--host hostname
Specifies the host name of the machine on which the
postmaster is running. If host begins with a slash,
it is used as the directory for the Unix-domain
socket.

Would it be overly verbose to mention the various PGHOST, PGDATA,
PGUSER, etc variables in the output of
`psql --help`?

Alex