From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Atul Kumar <akumar14871@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: IPV6 issue
Date: Mon, 27 Nov 2023 15:41:50 -0500
Message-ID: <4007721.1701117710@sss.pgh.pa.us> (raw)
In-Reply-To: <d6cdfb91-caf2-4f98-9d82-5019f5262ff5@aklaver.com>
References: <CA+ONtZ62uKURz1SLZqhJ1pwwFJB0BRXzPRN1zdAX3xo0Vo-JFQ@mail.gmail.com>
<CANzqJaAV7Tyahwrms=iRLR-_A1uMHgwWjMHMhpMYLgiyNT8iGQ@mail.gmail.com>
<CA+ONtZ7hGMKZDZHg4SVecZ3+mkPDwcey-P8wr7PTJSsrJ_e0eA@mail.gmail.com>
<d6cdfb91-caf2-4f98-9d82-5019f5262ff5@aklaver.com>
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 11/27/23 12:11, Atul Kumar wrote:
>> I found that localhost was set to .bash_profile and when I removed it
>> and then re-attempted to connected the database using "psql postgres", I
>> got this new error:
>>
>> psql postgres -p 5432
>> psql: error: 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.5432"?
> Do you have more then one version of psql installed?
Yeah, that. You're apparently using a version of psql/libpq that
thinks the default Unix socket location is /var/run/postgresql;
but the postmaster you are using did not create a socket there.
(Probably it put one in /tmp instead, which is the out-of-the-box
default location. But some distros consider that insecure so they
override it, typically to /var/run/postgresql/.)
The easiest workaround if you have a mishmash of Postgres libraries
is to tell the postmaster to create sockets in both places.
See "unix_socket_directories" parameter.
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: tgl@sss.pgh.pa.us, adrian.klaver@aklaver.com, akumar14871@gmail.com, ronljohnsonjr@gmail.com
Subject: Re: IPV6 issue
In-Reply-To: <4007721.1701117710@sss.pgh.pa.us>
References: <CA+ONtZ62uKURz1SLZqhJ1pwwFJB0BRXzPRN1zdAX3xo0Vo-JFQ@mail.gmail.com> <CANzqJaAV7Tyahwrms=iRLR-_A1uMHgwWjMHMhpMYLgiyNT8iGQ@mail.gmail.com> <CA+ONtZ7hGMKZDZHg4SVecZ3+mkPDwcey-P8wr7PTJSsrJ_e0eA@mail.gmail.com> <d6cdfb91-caf2-4f98-9d82-5019f5262ff5@aklaver.com> <4007721.1701117710@sss.pgh.pa.us>
* 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