Re: Ip address change of Postgres Sql DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux