pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (11+ messages)  latest in thread

Message-ID: <4007721.1701117710@sss.pgh.pa.us>
Permalink:  ../4007721.1701117710@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/4007721.1701117710@sss.pgh.pa.us

 · 

reply

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