From: abbas alizadeh <ramkly@yahoo.com>
To: Erik Serrano <eserranos@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
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> (raw)
In-Reply-To: <CA+dvXXsUgtOojKPaOwA7svjQSAEPwyi8bEcOSUKVbWWwYTu6WQ@mail.gmail.com>
References: <CA+dvXXsUgtOojKPaOwA7svjQSAEPwyi8bEcOSUKVbWWwYTu6WQ@mail.gmail.com>
--Apple-Mail-2C9500DB-3A63-4234-9A65-4013E88660EF
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div style=3D"direction: ltr;">Hi </di=
v><div style=3D"direction: ltr;">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.</div><div style=3D"directi=
on: ltr;">I suggest to use keepalive for VIP</div><div style=3D"direction: l=
tr;"><br></div><div style=3D"direction: ltr;">Regards</div><div style=3D"dir=
ection: ltr;">Abbas</div><div dir=3D"ltr"><br><blockquote type=3D"cite">On 2=
8 Dec 2022, at 7:58 PM, Erik Serrano <eserranos@gmail.com> wrote:<br><=
br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<d=
iv dir=3D"ltr">Hello guys,<br><br>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.<br>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) .<br>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.<br><br>I would greatly appreciate if you can give me ideas t=
o solve this problem to set up a laboratory and solve the problem.<br><br>Th=
ank you very much guys in advance<br>regards<br clear=3D"all"><div><div dir=3D=
"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D=
"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><br><i><b><br></b></i=
></div><div><i><b><font size=3D"4">Erik R. Serrano Saavedra</font></b></i></=
div><div><i style=3D"font-size:12.8px"><b>Ingeniero de Sistemas Inform=C3=A1=
ticos</b></i></div><div><i style=3D"font-size:12.8px"><b>  =
; Data Base Administrator</b></i></div><div><i><b>  =
; <a href=3D"mailto:eserranos@gmail.com" target=3D"_blank">eserranos@gm=
ail.com</a><br></b></i></div><div><i><b> &=
nbsp; 998596691</b></i><br></div><div><i><font style=3D"=
font-size:12pt" face=3D"Times New Roman" size=3D"3"><b>
</b></font></i><i><font style=3D"font-size:12pt" face=3D"Times New Roman" si=
ze=3D"3"><b><font style=3D"font-size:10pt" size=3D"2"></font></b></font></i>=
</div></div></div></div></div></div></div></div></div>
</div></blockquote></body></html>=
--Apple-Mail-2C9500DB-3A63-4234-9A65-4013E88660EF--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ramkly@yahoo.com, eserranos@gmail.com
Subject: Re: Listening ip in postgres database cluster
In-Reply-To: <0E7EFF68-0FFB-41B3-9E06-8B1AFF8F9B99@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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