Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433 - Mailing list pgsql-admin

From Devrim Gündüz
Subject Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433
Date
Msg-id 1475058469.24885.34.camel@gunduz.org
Whole thread Raw
In response to /var/run/postgresql/.s.PGSQL.5432 should be 5433  (Poul Kristensen <bcc5226@gmail.com>)
Responses Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433  (Poul Kristensen <bcc5226@gmail.com>)
List 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

Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433
Next
From: Poul Kristensen
Date:
Subject: Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433