From: Christoph Berg <myon@debian.org>
To: Mark Steben <mark.steben@drivedominion.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Fwd: cannot login to psql without specifying host
Date: Tue, 2 Oct 2018 13:30:07 +0200
Message-ID: <20181002113007.GI4343@msg.df7cb.de> (raw)
In-Reply-To: <CADyzmyw66x_SgxR=gX+RddQaBgHWVVW=eyNO2w_iygewF+piDw@mail.gmail.com>
References: <CADyzmyxeEW_a69A93ea8KNZvD7mTQUVb79MEY2NQn3-izB4rDw@mail.gmail.com>
<CADyzmyw66x_SgxR=gX+RddQaBgHWVVW=eyNO2w_iygewF+piDw@mail.gmail.com>
Re: Mark Steben 2018-10-02 <CADyzmyw66x_SgxR=gX+RddQaBgHWVVW=eyNO2w_iygewF+piDw@mail.gmail.com>
> *psql -U postgres prime_production -p 5433 *
> *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.5433"?*
>
> I have changed the UNIX_SOCKET_DIRECTORIES to something other than /tmp
> because we have another instance pointing to that directory. I restarted
> postgres. Didn't help. I have attached our 3 config files along with an
> ls -la listing of our database cluster directory. Any insights welcome.
You can use "psql -h /database/prime_data/PSQL_94/tmp" to use that
socket directory.
In practise, that will fail for any user than the cluster owner
because that is inside your PGDATA, and that is 0700.
Christoph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: myon@debian.org, mark.steben@drivedominion.com
Subject: Re: Fwd: cannot login to psql without specifying host
In-Reply-To: <20181002113007.GI4343@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox