Message-ID: <fc28ae44853cd7e769db396f938fd572b44b2237.camel@cybertec.at>
Subject: Re: Ip address change of Postgres Sql DB
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Jwiencek3 <jwiencek3@comcast.net>, "mukeshprasad_hit@yahoo.co.in"
	 <mukeshprasad_hit@yahoo.co.in>
Cc: "Pgsql-admin@postgresql.org" <Pgsql-admin@postgresql.org>
Date: Fri, 15 May 2020 15:16:17 +0200
In-Reply-To: <A804BFB8-550F-4660-945B-103025A6DB66@comcast.net>
References: <14722819.328388.1589547026725@mail.yahoo.com>
	 <A804BFB8-550F-4660-945B-103025A6DB66@comcast.net>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.32.5 (3.32.5-1.fc30) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

On Fri, 2020-05-15 at 07:53 -0500, Jwiencek3 wrote:
> > On May 15, 2020, at 7:50 AM, MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in> wrote:
> > I have postgres DB installed and i need to change ip address of this box. Post a
> > new op is assigned to box do we need to make any changes in any database configuration files etc.?
> > Please suggest 
>
> You will need to change Postgresql.conf and pg_hba.conf. Both located in the data directory.
> 
> Possible other changes depending on other products installed.   These two are the minimum.

Why?

The only reason to modify "postgresql.conf" would be if you have the network interface
rather than "*" or "localhost" in "listen_addresses".

"pg_hba.conf" is entirely independent of the server's IP address.

Yours,
Laurenz Albe