Re: Unix domain socket inconsistency

On 23 December 2013 01:13, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> On 12/22/2013 04:51 PM, Thom Brown wrote:
>
>> PostgreSQL using unix domain sockets by not specifying any host with
>> psql, and the same applies to vacuumdb, createdb and dropdb. However,
>> when I go to use pgbench, it seems to be looking in the wrong place
>> for the domain socket:
>>
>> thom(at)swift ~/Development/postgresql $ psql postgres
>> psql (9.4devel)
>> Type "help" for help.
>>
>> postgres=# \q
>> thom(at)swift ~/Development/postgresql $ createdb pgbench
>> thom(at)swift ~/Development/postgresql $ pgbench -i -s 20 pgbench
>> Connection to database "pgbench" failed:
>> could not connect to server: No such file or directory
>> Is the server running locally and accepting
>> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5488"?
>>
>> The actual location is /tmp/.s.PGSQL.5488:
>>
>> thom(at)swift ~/Development/postgresql $ pg_ctl stop
>> waiting for server to shut down....LOG: received smart shutdown request
>> LOG: autovacuum launcher shutting down
>> LOG: shutting down
>> LOG: database system is shut down
>> done
>> server stopped
>> thom(at)swift ~/Development/postgresql $ psql postgres
>> 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.5488"?
>>
>> What am I missing?
>
>
> Best guess pgbench is being run from a different install then rest of your
> Postgres set up. Might want to check whether you have more than one copy of
> pgbench and if so where they are in PATH.

I should have mentioned that I've checked that:

thom(at)swift ~/Development $ which psql pgbench
/home/thom/Development/psql/bin//psql
/home/thom/Development/psql/bin//pgbench

--
Thom