pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIp address change of Postgres Sql DB
8+ messages / 5 participants
[nested] [flat]
* Ip address change of Postgres Sql DB
@ 2020-05-15 12:50 MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
0 siblings, 1 reply; 8+ messages in thread
From: MUKESH PRASAD @ 2020-05-15 12:50 UTC (permalink / raw)
To: pgsql-admin
Hi experts, 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
Sent from Yahoo Mail on Android
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ip address change of Postgres Sql DB
@ 2020-05-15 12:53 Jwiencek3 <jwiencek3@comcast.net>
parent: MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
0 siblings, 2 replies; 8+ messages in thread
From: Jwiencek3 @ 2020-05-15 12:53 UTC (permalink / raw)
To: mukeshprasad_hit@yahoo.co.in <mukeshprasad_hit@yahoo.co.in>; +Cc: pgsql-admin
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.
Sent from my iPad
> On May 15, 2020, at 7:50 AM, MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in> wrote:
>
> Hi experts,
> 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
>
> Sent from Yahoo Mail on Android
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ip address change of Postgres Sql DB
@ 2020-05-15 12:55 MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
parent: Jwiencek3 <jwiencek3@comcast.net>
1 sibling, 1 reply; 8+ messages in thread
From: MUKESH PRASAD @ 2020-05-15 12:55 UTC (permalink / raw)
To: jwiencek3@comcast.net <jwiencek3@comcast.net>; +Cc: pgsql-admin
Thanks.. Do we have any documentation link on this topic. I searched but could not find anything.
Sent from Yahoo Mail on Android
On Fri, 15 May 2020 at 6:23 PM, Jwiencek3<jwiencek3@comcast.net> wrote: 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.
Sent from my iPad
On May 15, 2020, at 7:50 AM, MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in> wrote:
Hi experts, 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
Sent from Yahoo Mail on Android
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ip address change of Postgres Sql DB
@ 2020-05-15 13:16 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Jwiencek3 <jwiencek3@comcast.net>
1 sibling, 0 replies; 8+ messages in thread
From: Laurenz Albe @ 2020-05-15 13:16 UTC (permalink / raw)
To: Jwiencek3 <jwiencek3@comcast.net>; mukeshprasad_hit@yahoo.co.in <mukeshprasad_hit@yahoo.co.in>; +Cc: 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@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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ip address change of Postgres Sql DB
@ 2020-05-15 21:23 Lou Picciano <LouPicciano@comcast.net>
parent: MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
0 siblings, 1 reply; 8+ messages in thread
From: Lou Picciano @ 2020-05-15 21:23 UTC (permalink / raw)
To: mukeshprasad_hit@yahoo.co.in <mukeshprasad_hit@yahoo.co.in>; +Cc: jwiencek3@comcast.net <jwiencek3@comcast.net>; pgsql-admin
Vast resources - in documentation - on this topic; yes.
We haven’t made a PG cluster available on 5432 since… well, forever.
Lou Picciano
> On May 15, 2020, at 8:55 AM, MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in> wrote:
>
> Thanks.. Do we have any documentation link on this topic. I searched but could not find anything.
>
> Sent from Yahoo Mail on Android <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__Android...;
> On Fri, 15 May 2020 at 6:23 PM, Jwiencek3
> <jwiencek3@comcast.net> wrote:
> 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.
>
> Sent from my iPad
>
>> On May 15, 2020, at 7:50 AM, MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in> wrote:
>>
>
>> Hi experts,
>> 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
>>
>> Sent from Yahoo Mail on Android <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__Android...;
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ip address change of Postgres Sql DB
@ 2020-05-16 05:12 MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
parent: Lou Picciano <LouPicciano@comcast.net>
0 siblings, 2 replies; 8+ messages in thread
From: MUKESH PRASAD @ 2020-05-16 05:12 UTC (permalink / raw)
To: LouPicciano@comcast.net <LouPicciano@comcast.net>; +Cc: jwiencek3@comcast.net <jwiencek3@comcast.net>; pgsql-admin
Can you please help with sharing relevant links?
Sent from Yahoo Mail on Android
On Sat, 16 May 2020 at 2:53 AM, Lou Picciano<LouPicciano@comcast.net> wrote: Vast resources - in documentation - on this topic; yes.
We haven’t made a PG cluster available on 5432 since… well, forever.
Lou Picciano
On May 15, 2020, at 8:55 AM, MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in> wrote:
Thanks.. Do we have any documentation link on this topic. I searched but could not find anything.
Sent from Yahoo Mail on Android
On Fri, 15 May 2020 at 6:23 PM, Jwiencek3<jwiencek3@comcast.net> wrote: 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.
Sent from my iPad
On May 15, 2020, at 7:50 AM, MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in> wrote:
Hi experts, 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
Sent from Yahoo Mail on Android
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ip address change of Postgres Sql DB
@ 2020-05-16 05:29 David G. Johnston <david.g.johnston@gmail.com>
parent: MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
1 sibling, 0 replies; 8+ messages in thread
From: David G. Johnston @ 2020-05-16 05:29 UTC (permalink / raw)
To: mukeshprasad_hit@yahoo.co.in <mukeshprasad_hit@yahoo.co.in>; +Cc: LouPicciano@comcast.net <LouPicciano@comcast.net>; jwiencek3@comcast.net <jwiencek3@comcast.net>; pgsql-admin
On Fri, May 15, 2020 at 10:12 PM MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
wrote:
> Can you please help with sharing relevant links?
https://www.postgresql.org/docs/12/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS
David J.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Ip address change of Postgres Sql DB
@ 2020-05-18 06:19 Laurenz Albe <laurenz.albe@cybertec.at>
parent: MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
1 sibling, 0 replies; 8+ messages in thread
From: Laurenz Albe @ 2020-05-18 06:19 UTC (permalink / raw)
To: mukeshprasad_hit@yahoo.co.in <mukeshprasad_hit@yahoo.co.in>; LouPicciano@comcast.net <LouPicciano@comcast.net>; +Cc: jwiencek3@comcast.net <jwiencek3@comcast.net>; pgsql-admin
On Sat, 2020-05-16 at 05:12 +0000, MUKESH PRASAD wrote:
> Can you please help with sharing relevant links?
I think they cannot, because it is not true that you need to change the
configuration when changing the IP address.
As I said, the exception may be "listen_addresses":
https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-LISTEN-ADDRESSES
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2020-05-18 06:19 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-15 12:50 Ip address change of Postgres Sql DB MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
2020-05-15 12:53 ` Jwiencek3 <jwiencek3@comcast.net>
2020-05-15 12:55 ` MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
2020-05-15 21:23 ` Lou Picciano <LouPicciano@comcast.net>
2020-05-16 05:12 ` MUKESH PRASAD <mukeshprasad_hit@yahoo.co.in>
2020-05-16 05:29 ` David G. Johnston <david.g.johnston@gmail.com>
2020-05-18 06:19 ` Laurenz Albe <laurenz.albe@cybertec.at>
2020-05-15 13:16 ` Laurenz Albe <laurenz.albe@cybertec.at>
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