On Fri, 2020-05-15 at 07:53 -0500, Jwiencek3 wrote: > > On May 15, 2020, at 7:50 AM, MUKESH PRASAD <mukeshprasad_hit@xxxxxxxxxxx> 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
