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 1pAmIO-0005oP-LO for pgsql-admin@arkaria.postgresql.org; Thu, 29 Dec 2022 06:21:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pAmHN-0008TZ-La for pgsql-admin@arkaria.postgresql.org; Thu, 29 Dec 2022 06:20:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pAmHM-0008SP-OR for pgsql-admin@lists.postgresql.org; Thu, 29 Dec 2022 06:20:37 +0000 Received: from sonic308-8.consmr.mail.gq1.yahoo.com ([98.137.68.32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pAmHG-0007So-1t for pgsql-admin@postgresql.org; Thu, 29 Dec 2022 06:20:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1672294827; bh=t+Rv+SG8PlyL4cYyKl0Ah1emoo/P2n5YLF7pnG5amiA=; h=From:Subject:Date:References:Cc:In-Reply-To:To:From:Subject:Reply-To; b=fon46YQT9B1ZYrwmFlECS8kKd7pZw0PhSCZEWaKOzTWKkA8y7OmNQjUjL09tQnt903If996VDlGvH3PrGYdkF50z7gfeeNi3yitKZ8yTSKkiEYmTox7N+qasPST+vpIybnDSO/cJDoNwZ5UJDuzErt8Qrtpk5svb8f5XHVDpIbUyWNq8uAxtJdkEPBz9QXfqK2myW2a3zCFNbyYwr1uOzqtUFzFsOmFWR5FeCsaKhnmz8apaxZhUVRP85hO1OjBZqW4eVIg216lsaZkWQTyCjw9voiJlNCfKW35KVd4giLNYE1ONC6iBVZ7tgPbBm0yv7zJkglyQTZXe/2zjlrziUg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1672294827; bh=QnY3mf74bvuQL87FcXXcUuO3LkvP1+ZcomPIMHwCaNO=; h=X-Sonic-MF:From:Subject:Date:To:From:Subject; b=gCf9Ou2ig/ZTtWnjWY11Xqn2WS38m7hYMIh9LSh+A8GFcSGVGPxM1lLthMDQff8hAy/mAGZXBm/rTDhHBeDWMcgueLc6csOCKYJfYi+lOhmJT+aobZ41W0yoD54ZhdQfYjdnpqM3KZORBm53buEMLUVeDSB1evumQtPGw3weYisipN2egFoezd6mUX53TzShEwOD5MRxwFN8h0GcaBYoeT/n9/H2YPpsMFEGoOOWtTU+YVk8RlhGyqvSjIFSkTfFv/K70DXMrpx4EfsO6Wqcdbe0FqvES5CW37gE/4gc3L0PsX9irLM9f5hudtd0/5zsNdf3iybJG+R3jlcLzR8hmw== X-YMail-OSG: d1yOzJkVM1nbNDI7_qcApnv11TrFnC3u8XdhXfZnQmYsM3fbQVdnmba0TfapzRC 6Zli.hks5c7aMSZXJ9KIDvNNK5aPgZLoV.4fnXgD474CJ.TnRXqTgvjcVf4Rxj0fTjXN4K1bjs.n S8kPA9G4Pqe3U7o3qOSK94ju2NEn8jLVOQXyxEsQTPS7sWy4h_MUQbAXWTA0U7ccBURNbiy9VK5U _SOTtB.ewXoTd5MAJ2KUQkmsRNfcHMf2LBnOjZTy1MsmCJ.mWnGpJbR86a3fqbOtYUgz4obWWL4J _IE5nFif037jgmffV5pd1u52qhUXNWPH_EA2Nm46nkIfxjQoNPMDMBIFl3GgskBEjiTKWGaQf2rL C3T7WNTVYh1Yk8B7Eggq1gk1Ovbox.E7XuEJz8pep..8ykPmzeeDLYULAYyud7k73Bwzc0.xTQAc lBwFWjNOsi3ftaLDVE0co.HQaHwZPtu.drqf0WxsHkSzDWL63UTZucpUtiNb7fREWwx1z788nGUW PmYnzv2lhulusZ1GwsOUgkjFT92WrE_DvhQg7YDCu5dT6CW7Ov6_1.8r8wM_Y6HUnXZxmVwlyUa7 r0BZwEcVb9zqOsF__3pzT1m3ivgC.LN.celfoRoQczKrvzOP_Y.ejqnrd5y1cS9pJSWpF3sHNoxT .jK0ESY97BdXDUjX83NMsxQj7R6D.4d0xbcXs24jUq7YQ1Xw3QFO19b39FU.UkEWNjfPKAx9agbc eQBXoy9kBu5bGz9y17WY45AfGIA05DKNq0grU_Pdw7V1JF1CJygajXnRDaXj.a1wvBu67kqGZ3y9 sB_ZoPJ774ur3igVL_1l0iiMM6MN9br83E5.q7dSuX4Ags5mRF6fplgBppT5Zs6xTPVgrYktsOM7 0hvDTcBhYirmwZOJENtlTrOdX5._8dyu7_ovytiapHY.l.zxeehJCstzodqmqHYrtL405WCPpwIN jXBmbfjdunsyJ97WENb538y5IrTzBOFS1TMf.zTt4eG1SNmYBaK0zjJSrpg8T3CPMfulgU6SBmtF xhCwXCfc.FTlkGOrSkIqfZUfygLld7qDtzTEneNLzYhvYWbK7j7wboqlr.e4.vo6l0NBLLrHmVD5 85BOIIz97DgXzR3CoEeC.gszsqGJauuaSFMVgtNIYeVtgwhB9vAxKTu_qgu6gSs5qdcvYIEhwFE6 Mmd58hSFBsBLIqf2DT8y_DrJnFz8vigBBnRiiLIzAVdnJ2vLrnXMsKe6FNRrnG4qby1L08A9_s7L TxCT2A74oUv3gnfZ0Kkk2PGNT.qHzpDSNaZNey80MYbyDSRtUhsyzT4xFwMJNscH8j50jwsHWl.i JIkRRL7eh0QL0UwB_.H8vRvoq5t0GAJ0HzzQx4P0Miq3e9suny0viHu3QGtTG6jgeOMOSEyaPHB4 9uOaPMhavUluWLlyuCRrfSEqktKG2EgYz8tQtRClUXXrH1HpOlC3nlPD0mDH7uPRhKWobCMts8C9 hVahazF2VJrFq2ABOXmzvu6o.jO_ofbCgNVc0JAsube5OxmA2H6ChrPd1An_SvWF51vqS.NfsA8w 9V2hTYdDeZ.zUT5VCvg_SMf.xY.q2brv2BJa7ZS7VMoch.4EN0sn3W9mGg2quKWCCrCaM8R3eKX. 3qa56VmlXW6U7sOtshet950szUxci3NYHF5Q5s001UgQnPpYEogHMQ3Nq8cHNvpzOEkRC7.b0Inq WO.Q6e4ry_GrP.lIq1cungppcv4LfgTDIaZCkwHiPGRLze9YU6Y8QCTOEkcZrZiUfprC8MF0GGLO J1nPUiG.x9YHbKzzSm1gBC4xNAB7BVGFiMZWvfEMyfILEEghsCCmxDrTghb95GLrwtAP8RnmEuR9 oRD4okDYmem7lLUTEyFyZ7Jl5OsppwBKT6FGNXt.ZBmCUzxZoCtdVG2NK0xx7wsT9bBT5mHIo5SP O2u_xKNApIWRIue7mLJN1X6mzuvH58FaSw.8fbzJgv1SCtXs7HqVsb4DXi2pzNKYqsu69HEBEiIq Yy3zbIuVsbbl4ftnlKg.LhV5_yGlK0Ze2Ma8S7SCE5qDaTit8f5QPFc4nBGc1bdwqvFSON4.N8jn mPN9UFBjQFNzAvoIrrE2mX6XAyqrEV.nKLsZwfqnb6qY4qplbsuXbenlfygt1COVAhGUFt2vt1bV pU.zAxmqjDPMnzVAHP5qWFFLBvI9Yp4N4yE0d.T5QSwVNu271yRDVSxoeMJ.ieN1UBFLCdm7dkgn NFFsBeWslngk.tQsHXBfl7xmUGPKw.RsAufAzQuiwADHwo1moR2j1uhU- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.gq1.yahoo.com with HTTP; Thu, 29 Dec 2022 06:20:27 +0000 Received: by hermes--production-ir2-5795fc58c8-rvf4r (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID a74f6623a2df614873484add7d32ff36; Thu, 29 Dec 2022 06:20:20 +0000 (UTC) Content-Type: multipart/alternative; boundary=Apple-Mail-2C9500DB-3A63-4234-9A65-4013E88660EF Content-Transfer-Encoding: 7bit From: abbas alizadeh Mime-Version: 1.0 (1.0) Subject: Re: Listening ip in postgres database cluster Date: Thu, 29 Dec 2022 10:20:07 +0400 Message-Id: <0E7EFF68-0FFB-41B3-9E06-8B1AFF8F9B99@yahoo.com> References: Cc: pgsql-admin In-Reply-To: To: Erik Serrano X-Mailer: iPhone Mail (20B101) Content-Length: 2995 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-2C9500DB-3A63-4234-9A65-4013E88660EF Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi 
You need to assign a virtual IP (VIP) to yo= ur cluster and applications using VIP to connect instead if physical IP so i= n case of failover VIP will assign to new master.
I suggest to use keepalive for VIP

Regards
Abbas

On 2= 8 Dec 2022, at 7:58 PM, Erik Serrano <eserranos@gmail.com> wrote:
<= br>
=EF=BB=BFHello guys,

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

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

Th= ank you very much guys in advance
regards


Erik R. Serrano Saavedra
Ingeniero de Sistemas Inform=C3=A1= ticos
     = ; Data Base Administrator
       = ; eserranos@gm= ail.com
          &= nbsp;      998596691
=
= --Apple-Mail-2C9500DB-3A63-4234-9A65-4013E88660EF--