Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZhnp-00060J-8q for pgsql-admin@arkaria.postgresql.org; Fri, 15 May 2020 21:23:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jZhnl-00027r-QY for pgsql-admin@arkaria.postgresql.org; Fri, 15 May 2020 21:23:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZhnl-00027k-4o for pgsql-admin@lists.postgresql.org; Fri, 15 May 2020 21:23:29 +0000 Received: from resqmta-ch2-12v.sys.comcast.net ([2001:558:fe21:29:69:252:207:44]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZhnc-0000Wn-8n for pgsql-admin@postgresql.org; Fri, 15 May 2020 21:23:28 +0000 Received: from resomta-ch2-04v.sys.comcast.net ([69.252.207.100]) by resqmta-ch2-12v.sys.comcast.net with ESMTP id ZhhbjnvdgUcArZhnWjIVih; Fri, 15 May 2020 21:23:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1589577794; bh=r3TyTqb784c4dxcP6cOzOM9KlXNK9zrjNk5eGP4bEEA=; h=Received:Received:Content-Type:Mime-Version:Subject:From:Date: Message-Id:To; b=PYqjmpiV7viq1H5/7pft0/LHMf2WVNuI4c9w0huS7ZB79oFmBuUlFNW8k+b3iiw36 ASFVj4w5ztZJgKUWzPFovyHzOfZ2ZgKO1FqK9nO1p4aRkhIrW4rk9h7qIg2xyKoH0H LWAq+b6y85hcK9OepnsUNGPg2zwXsrMOc0EfWysBuONKiL/ojx2MN8iM7yBh+2iTIM RfVPIF/P9adF882bGI+4OlYtOxHclAlkcHy9FdllfdDyT40B+0jjKl2cpGvuQTBAbP ENlzhTuYv/t5cOQbv+ZGnz1LxtK+7Fd4TF2Bd/PN9biO9JmgpDGAYMqk3hjT8G/Hlk FhQysayGNd56w== Received: from [192.168.42.10] ([76.117.230.110]) by resomta-ch2-04v.sys.comcast.net with ESMTPSA id ZhnSjvflAHgVhZhnTjQ1EO; Fri, 15 May 2020 21:23:14 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgeduhedrleekgdduheekucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuvehomhgtrghsthdqtfgvshhipdfqfgfvpdfpqffurfetoffkrfenuceurghilhhouhhtmecufedttdenucenucfjughrpegtggfuhfgjfffkfhfvofesrgdtmherhhdtjeenucfhrhhomhepnfhouhcurfhitggtihgrnhhouceonfhouhfrihgttghirghnohestghomhgtrghsthdrnhgvtheqnecuggftrfgrthhtvghrnhephefhleetgffhhfdvgeekvdeuuddvhfdtffeuieduueegffekhfffheefvdegtdfgnecuffhomhgrihhnpehonhgvlhhinhhkrdhmvgenucfkphepjeeirdduudejrddvfedtrdduuddtnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehhvghloheplgduledvrdduieekrdegvddruddtngdpihhnvghtpeejiedruddujedrvdeftddruddutddpmhgrihhlfhhrohhmpehlohhuphhitggtihgrnhhosegtohhmtggrshhtrdhnvghtpdhrtghpthhtohepmhhukhgvshhhphhrrghsrggupghhihhtseihrghhohhordgtohdrihhnpdhrtghpthhtohepjhifihgvnhgtvghkfeestghomhgtrghsthdrnhgvthdprhgtphhtthhopehpghhsqhhlqdgrughmihhnsehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehfrhgrnhgtoheshhhothgvlhgrqhhurgdrihht X-Xfinity-VMeta: sc=0.00;st=legit Content-Type: multipart/alternative; boundary="Apple-Mail=_61C05948-EE5B-4A94-A848-5A7474911DF1" Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.11\)) Subject: Re: Ip address change of Postgres Sql DB From: Lou Picciano In-Reply-To: <673731775.328672.1589547322304@mail.yahoo.com> Date: Fri, 15 May 2020 17:23:09 -0400 Cc: "jwiencek3@comcast.net" , "Pgsql-admin@postgresql.org" Message-Id: References: <14722819.328388.1589547026725@mail.yahoo.com> <673731775.328672.1589547322304@mail.yahoo.com> To: "mukeshprasad_hit@yahoo.co.in" X-Mailer: Apple Mail (2.3445.104.11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_61C05948-EE5B-4A94-A848-5A7474911DF1 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Vast resources - in documentation - on this topic; yes. We haven=E2=80=99t made a PG cluster available on 5432 since=E2=80=A6 = well, forever. Lou Picciano > On May 15, 2020, at 8:55 AM, MUKESH PRASAD = wrote: >=20 > Thanks.. Do we have any documentation link on this topic. I searched = but could not find anything.=20 >=20 > Sent from Yahoo Mail on Android = > On Fri, 15 May 2020 at 6:23 PM, Jwiencek3 > wrote: > You will need to change Postgresql.conf and pg_hba.conf. Both located = in the data directory. >=20 > Possible other changes depending on other products installed. These = two are the minimum.=20 >=20 > Sent from my iPad >=20 >> On May 15, 2020, at 7:50 AM, MUKESH PRASAD = wrote: >>=20 >=20 >> =EF=BB=BFHi experts,=20 >> 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=20 >>=20 >> Sent from Yahoo Mail on Android = --Apple-Mail=_61C05948-EE5B-4A94-A848-5A7474911DF1 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Vast = resources - in documentation - on this topic; yes.

We haven=E2=80=99t made a PG cluster available on = 5432 since=E2=80=A6 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. 


=
=
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:

=EF=BB=BFHi 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 

=

= --Apple-Mail=_61C05948-EE5B-4A94-A848-5A7474911DF1--