pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedListening ip in postgres database cluster
4+ messages / 4 participants
[nested] [flat]
* Listening ip in postgres database cluster
@ 2022-12-28 15:58 Erik Serrano <eserranos@gmail.com>
0 siblings, 3 replies; 4+ messages in thread
From: Erik Serrano @ 2022-12-28 15:58 UTC (permalink / raw)
To: pgsql-admin
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áticos*
* Data Base Administrator*
* eserranos@gmail.com <eserranos@gmail.com>*
* 998596691*
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Listening ip in postgres database cluster
@ 2022-12-28 15:59 John Wiencek <jwiencek3@comcast.net>
parent: Erik Serrano <eserranos@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: John Wiencek @ 2022-12-28 15:59 UTC (permalink / raw)
To: Erik Serrano <eserranos@gmail.com>; +Cc: pgsql-admin
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áticos
> Data Base Administrator
> eserranos@gmail.com <mailto:eserranos@gmail.com>
> 998596691
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Listening ip in postgres database cluster
@ 2022-12-29 06:20 abbas alizadeh <ramkly@yahoo.com>
parent: Erik Serrano <eserranos@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: abbas alizadeh @ 2022-12-29 06:20 UTC (permalink / raw)
To: Erik Serrano <eserranos@gmail.com>; +Cc: pgsql-admin
--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--
^ permalink raw reply [nested|flat] 4+ messages in thread
* Fwd: Listening ip in postgres database cluster
@ 2022-12-30 20:16 Everson Kalaf <everson.kalaf@gmail.com>
parent: Erik Serrano <eserranos@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Everson Kalaf @ 2022-12-30 20:16 UTC (permalink / raw)
To: pgsql-admin
if you use patroni, you can use Haproxy and keepalived
[image: image.png]
Em qua., 28 de dez. de 2022 às 12:58, Erik Serrano <eserranos@gmail.com>
escreveu:
> 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áticos*
> * Data Base Administrator*
>
> * eserranos@gmail.com <eserranos@gmail.com>*
> * 998596691*
>
--
Atenciosamente,
Everson Kalaf
Oracle Database SQL Certified Expert
ITIL® Foundation V3
MCSE: Data Platform SQL Server® 2012
MCSA: SQL Server® 2012
MCITP: Database Administrator 2008
MCITP: Administrador de Servidor Windows Server 2008
MCTS Implementação e Manutenção SQL Server 2008
MCTS Infraestrutura de Redes Windows Server 2008
MCTS Active Directory Windows Server Server 2008
Microsoft Certified Solutions Associate
MCSA / MCDST / MCP
--
Atenciosamente,
Everson Kalaf
Oracle Database SQL Certified Expert
ITIL® Foundation V3
MCSE: Data Platform SQL Server® 2012
MCSA: SQL Server® 2012
MCITP: Database Administrator 2008
MCITP: Administrador de Servidor Windows Server 2008
MCTS Implementação e Manutenção SQL Server 2008
MCTS Infraestrutura de Redes Windows Server 2008
MCTS Active Directory Windows Server Server 2008
Microsoft Certified Solutions Associate
MCSA / MCDST / MCP
Attachments:
[image/png] image.png (422.0K, ../../CAC0aDr5G2UDxQUaibNc0xF9doJWOaKqKPX2=XJFN5Z5xNtGC8A@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-12-30 20:16 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-28 15:58 Listening ip in postgres database cluster Erik Serrano <eserranos@gmail.com>
2022-12-28 15:59 ` John Wiencek <jwiencek3@comcast.net>
2022-12-29 06:20 ` abbas alizadeh <ramkly@yahoo.com>
2022-12-30 20:16 ` Everson Kalaf <everson.kalaf@gmail.com>
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