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

From: Devrim Gündüz <devrim(at)gunduz(dot)org>
To: Poul Kristensen <bcc5226(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433
Date: 2016-09-28 10:27:49
Message-ID: 1475058469.24885.34.camel@gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

On Tue, 2016-09-27 at 10:08 +0200, Poul Kristensen wrote:
> 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.
>
> How come and how do I change this?

If you installed Postgres from Red Hat repos (likely), then change the port
number in unit file for the second instance. The recommended way is copying the
unit file under /etc/systemd/system/ and modify from there.

If you installed from PGDG repos, then changing port from postgresql.conf is
sufficient.

Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Poul Kristensen 2016-09-28 11:32:55 Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433
Previous Message Tom Lane 2016-09-27 16:08:29 Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433