pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Teja Jakkidi <teja.jakkidi05@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Postgres open source upgrades
Date: Tue, 28 Jun 2022 16:26:11 -0400
Message-ID: <2748258.1656447971@sss.pgh.pa.us> (raw)
In-Reply-To: <AAE7AA79-1C07-4365-BC0B-4282A518E6FB@gmail.com>
References: <YrtgFX7Zu04ctk3e@momjian.us>
	<AAE7AA79-1C07-4365-BC0B-4282A518E6FB@gmail.com>

Teja Jakkidi <teja.jakkidi05@gmail.com> writes:
> Cluster started and I was able to connect remotely with no issues. However when I tried using psql, I got below error:
>         Connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed.
> But my postgres has been using socket file in /tmp location before upgrade. I am not sure why after upgrade psql is searching at a different allocation for socket. 
> Can someone help me here? 

Some distributions configure the code with a different default socket
location because they don't like putting the socket in /tmp.  It's
best to use a server and libraries all built by the same source so
that you don't have to fight with decisions like that.  If you have
to, though, it's possible to force the server to put its socket
where you want (see unix_socket_directories).

			regards, tom lane





view thread (9+ messages)  latest in thread

Message-ID: <2748258.1656447971@sss.pgh.pa.us>
Permalink:  ../2748258.1656447971@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2748258.1656447971@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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, teja.jakkidi05@gmail.com, bruce@momjian.us, pgsql-admin@lists.postgresql.org
  Subject: Re: Postgres open source upgrades
  In-Reply-To: <2748258.1656447971@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