From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Unix domain socket inconsistency |
Date: | 2013-12-23 00:51:07 |
Message-ID: | CAA-aLv525Q1TTUQ8EheWzrePpHt0yU_nCNfguSBgNHJpMpK3Ew@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I'm a bit confused by my development set up. I can connect to
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?
--
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-12-23 01:13:13 | Re: Unix domain socket inconsistency |
Previous Message | Gavin Flower | 2013-12-21 02:42:28 | Re: to_json(now()) result doesn't have 'T' separator |