MIME-Version: 1.0
From: Erik Serrano <eserranos@gmail.com>
Date: Mon, 2 Dec 2024 13:34:33 -0300
Message-ID: 
 <CA+dvXXv_t-88oXC3m1EL4Oa+MwizO0+4azhAzW-OeJgEG9Kf+A@mail.gmail.com>
Subject: Database disconnection due to timeout
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000048f66c06284c20ae"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BdvXXv_t-88oXC3m1EL4Oa%2BMwizO0%2B4azhAzW-OeJgEG9Kf%2BA%40mail.gmail.com>
Precedence: bulk

--00000000000048f66c06284c20ae
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi guys, nice to meet you .. I have to solve a user problem against the
postgresql database that is located in the Azure cloud as (IaaS) that is
happening to you the following:

A user drops the connection from his console to the replica slave database
due to timeout, it is possible that there is a parameter within the
configuration file (postgresql.conf) connection (pg_hba.conf) or replica
manager (repmgr.conf) that allows me to solve this problem.


Background:
- The database is in an Azure IaaS.
- The database allows the connection, but the user drops due to timeout
- I can connect to the same server and database with their credentials
- Firewall allows the connection.
- the configuration in pg_hba.conf owns the user
- user connects through DBeaver
- The database postgreSQL is version 15
- user is the owner of the database

Any contribution is appreciated.

Thank you very much for your contributions and help.
Greetings


*Erik R. Serrano Saavedra*
*Ingeniero de Sistemas Inform=C3=A1ticos*

--00000000000048f66c06284c20ae
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi guys, nice to meet you .. I have to solve a user p=
roblem against the postgresql database that is located in the Azure cloud a=
s (IaaS) that is happening to you the following:<br><br>A user drops the co=
nnection from his console to the replica slave database due to timeout, it =
is possible that there is a parameter within the configuration file (postgr=
esql.conf) connection (pg_hba.conf) or replica manager (repmgr.conf) that a=
llows me to solve this problem.<br><br><br>Background:<br>- The database is=
 in an Azure IaaS.<br>- The database allows the connection, but the user dr=
ops due to timeout<br>- I can connect to the same server and database with =
their credentials<br>- Firewall allows the connection.<br>- the configurati=
on in pg_hba.conf owns the user<br>- user connects through DBeaver<br>- The=
 database postgreSQL is version 15<br>- user is the owner of the database</=
div><div><br></div><div>Any contribution is appreciated.</div><div><br></di=
v><div>Thank you very much for your contributions and help.<br>Greetings</d=
iv><div><br></div><div><div dir=3D"ltr" class=3D"gmail_signature" data-smar=
tmail=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div =
dir=3D"ltr"><div><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=A1ticos</b></i></div><div><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" s=
ize=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>

--00000000000048f66c06284c20ae--