From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Jwiencek3 <jwiencek3@comcast.net>
To: mukeshprasad_hit@yahoo.co.in <mukeshprasad_hit@yahoo.co.in>
Cc: Pgsql-admin@postgresql.org <Pgsql-admin@postgresql.org>
Subject: Re: Ip address change of Postgres Sql DB
Date: Fri, 15 May 2020 15:16:17 +0200
Message-ID: <fc28ae44853cd7e769db396f938fd572b44b2237.camel@cybertec.at> (raw)
In-Reply-To: <A804BFB8-550F-4660-945B-103025A6DB66@comcast.net>
References: <14722819.328388.1589547026725@mail.yahoo.com>
<A804BFB8-550F-4660-945B-103025A6DB66@comcast.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, jwiencek3@comcast.net, mukeshprasad_hit@yahoo.co.in
Subject: Re: Ip address change of Postgres Sql DB
In-Reply-To: <fc28ae44853cd7e769db396f938fd572b44b2237.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox