Re: IPV6 issue - Mailing list pgsql-general

On 11/27/23 16:58, Atul Kumar wrote:
> I Don't know how postgres was installed,

1) Someone installed it. Ask around on where it came from.

2) Query the package manager to see if it was installed that way?


> 
> How do I check if I have more than one version of psql installed ?

A quick and dirty way to see what you are using:

    whereis psql

To find all the versions:

    sudo find / -name  psql

> 
> 
> Regards.
> 
> On Tue, Nov 28, 2023 at 6:26 AM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 11/27/23 16:42, Atul Kumar wrote:
>      > Hi,
>      >
>      > unix_socket_directories is set to default i.e. /tmp and I could
>     see the
>      > socket in /tmp directory.
> 
>     You have not answered:
> 
>          How did you install Postgres?
> 
>          Do you have more then one version of psql installed?
> 
> 
>     Though I am pretty sure I know the answer to the second question.
> 
> 
>      >
>      >
>      > Regards.
>      >
>      >
>      >
>      >
>      > On Tue, Nov 28, 2023 at 2:11 AM Tom Lane <tgl@sss.pgh.pa.us
>     <mailto:tgl@sss.pgh.pa.us>
>      > <mailto:tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>>> wrote:
>      >
>      >     Adrian Klaver <adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.com>
>      >     <mailto:adrian.klaver@aklaver.com
>     <mailto: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
>      >
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com