Re: Postgres open source upgrades

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
searchingat 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