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@swift ~/Development/postgresql $ psql postgres
psql (9.4devel)
Type "help" for help.
postgres=# \q
thom@swift ~/Development/postgresql $ createdb pgbench
thom@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@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@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.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
