MIME-Version: 1.0
References: 
 <CA+dvXXv_t-88oXC3m1EL4Oa+MwizO0+4azhAzW-OeJgEG9Kf+A@mail.gmail.com>
 <CANzqJaDXq5Jzigzzh0L7OgiEXNPF__r7j_gOoGL=GgA+uQ__rQ@mail.gmail.com>
In-Reply-To: 
 <CANzqJaDXq5Jzigzzh0L7OgiEXNPF__r7j_gOoGL=GgA+uQ__rQ@mail.gmail.com>
From: Erik Serrano <eserranos@gmail.com>
Date: Mon, 2 Dec 2024 17:43:20 -0300
Message-ID: 
 <CA+dvXXvhyk_P9Xp6jgs-89-tBn4=TE5=UO2rWxBQZ-iEO+b6gQ@mail.gmail.com>
Subject: Re: Database disconnection due to timeout
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000001909906284f9a91"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BdvXXvhyk_P9Xp6jgs-89-tBn4%3DTE5%3DUO2rWxBQZ-iEO%2Bb6gQ%40mail.gmail.com>
Precedence: bulk

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

Friends,

In the end I managed to detect that the failure was caused by a delay in
the connection that was established with respect to the timeout parameter
that was defined in postgresql.conf. It is adjusted and the user can
establish the connection. Additionally, the DBeaver that the user owns
presents problems in its JDBC with respect to version PG 15.

Thank you very much for the support and accurate solution.


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


El lun, 2 dic 2024 a las 17:10, Ron Johnson (<ronljohnsonjr@gmail.com>)
escribi=C3=B3:

> On Mon, Dec 2, 2024 at 11:34=E2=80=AFAM Erik Serrano <eserranos@gmail.com=
> wrote:
>
>> 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.
>>
>
> Disconnect during any random query?
> Disconnect only during a very long-running query?
> Disconnect when DBeaver is "just sitting there", while the user is doing
> something else?
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"ltr"><div><br clear=3D"all"></div><div>Friends,=C2=A0</div><div=
><br></div><div>In the end I managed to detect that the failure was caused =
by a delay in the connection that was established with respect to the timeo=
ut parameter that was defined in postgresql.conf. It is adjusted and the us=
er can establish the connection. Additionally, the DBeaver that the user ow=
ns presents problems in its JDBC with respect to version PG 15.<br><br>Than=
k you very much for the support and accurate solution.</div><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 Inf=
orm=C3=A1ticos</b></i></div><div><br></div></div></div></div></div></div></=
div></div></div><br><div class=3D"gmail_quote gmail_quote_container"><div d=
ir=3D"ltr" class=3D"gmail_attr">El lun, 2 dic 2024 a las 17:10, Ron Johnson=
 (&lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a=
>&gt;) escribi=C3=B3:<br></div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Mon, Dec 2, 2024 at 11:34=E2=80=
=AFAM Erik Serrano &lt;<a href=3D"mailto:eserranos@gmail.com" target=3D"_bl=
ank">eserranos@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi guy=
s, nice to meet you .. I have to solve a user problem against the postgresq=
l database that is located in the Azure cloud as (IaaS) that is happening t=
o you the following:<br><br>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_hb=
a.conf) or replica manager (repmgr.conf) that allows me to solve this probl=
em.<br><br><br>Background:<br>- The database is in an Azure IaaS.<br>- The =
database allows the connection, but the user drops due to timeout<br>- I ca=
n connect to the same server and database with their credentials<br>- Firew=
all allows the connection.<br>- the configuration in pg_hba.conf owns the u=
ser<br>- user connects through DBeaver<br>- The database postgreSQL is vers=
ion 15<br>- user is the owner of the database</div><div><br></div><div>Any =
contribution is appreciated.</div></div></blockquote><div><br></div><div>Di=
sconnect during any random query?</div><div>Disconnect only during a very l=
ong-running query?</div><div>Disconnect when DBeaver is &quot;just sitting =
there&quot;, while the user is doing something else?</div><div><br></div></=
div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" c=
lass=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and bu=
tter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Re=
dacted&gt; lobster!</div></div></div></div></div></div>
</blockquote></div>

--00000000000001909906284f9a91--