Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433

From: Scott Mead <scottm(at)openscg(dot)com>
To: Poul Kristensen <bcc5226(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433
Date: 2016-09-27 15:16:27
Message-ID: CAKq0gvL-jahD+WwwRbJvPvo3J-XRAJnfcCowxHytXEeEV2zO-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Sep 27, 2016 at 4:08 AM, Poul Kristensen <bcc5226(at)gmail(dot)com> wrote:

> Hi !
>
> I have need to have to difference Postgres version runnung on the same
> RHEL 7.2 server.
>
> They are listening on 2 different ports as configured but socket is still
> listening
> on port 5432 for both of them.
>

1. What version of postgres?
2. Where did you get your binaries from ? PGDG, etc...

In your postgresql.conf for each instance, what do you have for:

listen_addresses=?
port=?
unix_socket_directories=?

Most likely, the second instance you created has the socket in /tmp/,
whereas the one created by the RPMs has the socket in /tmp AND
/var/run/postgresql

--Scott

>
> How come and how do I change this?
>
> TIA
>
> Poul
>
>

--
--
Scott Mead
Sr. Architect
*OpenSCG <http://openscg.com>*
http://openscg.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2016-09-27 16:08:29 Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433
Previous Message Alvaro Herrera 2016-09-27 14:51:00 Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433