| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Jwiencek3 <jwiencek3(at)comcast(dot)net>, "mukeshprasad_hit(at)yahoo(dot)co(dot)in" <mukeshprasad_hit(at)yahoo(dot)co(dot)in> |
| Cc: | "Pgsql-admin(at)postgresql(dot)org" <Pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Ip address change of Postgres Sql DB |
| Date: | 2020-05-15 13:16:17 |
| Message-ID: | fc28ae44853cd7e769db396f938fd572b44b2237.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 2020-05-15 at 07:53 -0500, Jwiencek3 wrote:
> > On May 15, 2020, at 7:50 AM, MUKESH PRASAD <mukeshprasad_hit(at)yahoo(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lou Picciano | 2020-05-15 21:23:09 | Re: Ip address change of Postgres Sql DB |
| Previous Message | MUKESH PRASAD | 2020-05-15 12:55:22 | Re: Ip address change of Postgres Sql DB |