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 1pAYt1-0000zw-VD for pgsql-admin@arkaria.postgresql.org; Wed, 28 Dec 2022 16:02:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pAYs2-0000SP-QE for pgsql-admin@arkaria.postgresql.org; Wed, 28 Dec 2022 16:01:34 +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 1pAYs1-0000SE-Pi for pgsql-admin@lists.postgresql.org; Wed, 28 Dec 2022 16:01:34 +0000 Received: from resqmta-h1p-028588.sys.comcast.net ([2001:558:fd02:2446::a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pAYrx-0000GO-T3 for pgsql-admin@postgresql.org; Wed, 28 Dec 2022 16:01:32 +0000 Received: from resomta-h1p-027916.sys.comcast.net ([96.102.179.203]) by resqmta-h1p-028588.sys.comcast.net with ESMTP id AX7fpEFGdISSAAYqcpmAfO; Wed, 28 Dec 2022 16:00:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1672243206; bh=KsId15zRY0EpafpJJ4QqWJLcIVhlot4tq3QUssCExkE=; h=Received:Received:From:Message-Id:Content-Type:Mime-Version: Subject:Date:To:Xfinity-Spam-Result; b=Vb8MaJ4psyWPA3OH9EwMuv9efnNcQicVa1JqeqiOJJqhHHVh2OmwGZZc9HshM5jHE IoMRhReHib3gqFf7wspFcECB8Nbe0vWXy5yjbMbszvjFBpv8stiq0BuC+5IYEB92ch iNR9v/1xTJms13WNgy0+AUP/z0f+BYgSQVBVnXgYsIOxrIphLmOduI9/l+amKA95lq dtXMOIyvgApIqNpb5EpFra10Xt+lQjVcZU5igUpdk5c32MtBCn5YJqtxCDnYjUuw4h 8973fKdjEnfIEF+GxRx5cYTF3tgAbUG5aqH6BP0A5xLrOlx2lTUcgulhL/xKmkxbB1 Hl1kPSIfy/1FA== Received: from smtpclient.apple ([IPv6:2601:240:d000:c160:1491:8b86:de6f:bc29]) by resomta-h1p-027916.sys.comcast.net with ESMTPA id AYqTpMVLuRKxLAYqVpGQUj; Wed, 28 Dec 2022 15:59:59 +0000 X-Xfinity-VMeta: sc=0.00;st=legit From: John Wiencek Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_497E7E13-2029-4E22-9D5A-381A0EC47E6F" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.200.110.1.12\)) Subject: Re: Listening ip in postgres database cluster Date: Wed, 28 Dec 2022 09:59:47 -0600 In-Reply-To: Cc: pgsql-admin To: Erik Serrano References: X-Mailer: Apple Mail (2.3731.200.110.1.12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_497E7E13-2029-4E22-9D5A-381A0EC47E6F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Look up using Virtual IP (VIP). > On Dec 28, 2022, at 9:58 AM, Erik Serrano wrote: >=20 > Hello guys, >=20 > I have a question, it happens that I have a monitoring web application = that connects to my postgresql onpremise database... so far so good, = however I need to do a HA cluster replication between the databases and = the tests I have done have worked in my laboratory. > However, I have 2 nodes that replicate with different ips... but my = application should only see one ip, and when it changes due to failover = it stops seeing the server and I must change it manually and restore it = when I do the switchover (go back or normalize the database cluster) . > I would like to know if there is any open source application, script = or configuration that allows switching the IPs in case of failover... = something like a listener (sqlserver) but postgres. >=20 > I would greatly appreciate if you can give me ideas to solve this = problem to set up a laboratory and solve the problem. >=20 > Thank you very much guys in advance > regards >=20 >=20 > Erik R. Serrano Saavedra > Ingeniero de Sistemas Inform=C3=A1ticos > Data Base Administrator > eserranos@gmail.com > 998596691 --Apple-Mail=_497E7E13-2029-4E22-9D5A-381A0EC47E6F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Look up using =  Virtual IP (VIP).

On = Dec 28, 2022, at 9:58 AM, Erik Serrano <eserranos@gmail.com> = wrote:

Hello guys,

I have a question, it happens that I have = a monitoring web application that connects to my postgresql onpremise = database... so far so good, however I need to do a HA cluster = replication between the databases and the tests I have done have worked = in my laboratory.
However, I have 2 nodes that replicate with = different ips... but my application should only see one ip, and when it = changes due to failover it stops seeing the server and I must change it = manually and restore it when I do the switchover (go back or normalize = the database cluster) .
I would like to know if there is any open = source application, script or configuration that allows switching the = IPs in case of failover... something like a listener (sqlserver) but = postgres.

I would greatly appreciate if you can give me ideas to = solve this problem to set up a laboratory and solve the = problem.

Thank you very much guys in advance
regards


Erik R. Serrano Saavedra
Ingeniero de Sistemas = Inform=C3=A1ticos
      Data Base = Administrator
      =   eserranos@gmail.com
&nbs= p;               =  998596691

= --Apple-Mail=_497E7E13-2029-4E22-9D5A-381A0EC47E6F--