MIME-Version: 1.0
References: 
 <CA+dvXXv_t-88oXC3m1EL4Oa+MwizO0+4azhAzW-OeJgEG9Kf+A@mail.gmail.com>
In-Reply-To: 
 <CA+dvXXv_t-88oXC3m1EL4Oa+MwizO0+4azhAzW-OeJgEG9Kf+A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 2 Dec 2024 15:10:33 -0500
Message-ID: 
 <CANzqJaDXq5Jzigzzh0L7OgiEXNPF__r7j_gOoGL=GgA+uQ__rQ@mail.gmail.com>
Subject: Re: Database disconnection due to timeout
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b945d506284f2413"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaDXq5Jzigzzh0L7OgiEXNPF__r7j_gOoGL%3DGgA%2BuQ__rQ%40mail.gmail.com>
Precedence: bulk

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

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 databas=
e
> 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?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Dec 2, 2024 at 11:34=E2=80=AFAM E=
rik Serrano &lt;<a href=3D"mailto:eserranos@gmail.com">eserranos@gmail.com<=
/a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex"><div dir=3D"ltr"><div>Hi guys, nice to meet you .. I =
have to solve a user problem against the postgresql database that is locate=
d in the Azure cloud as (IaaS) that is happening to you the following:<br><=
br>A user drops the connection from his console to the replica slave databa=
se due to timeout, it is possible that there is a parameter within the conf=
iguration file (postgresql.conf) connection (pg_hba.conf) or replica manage=
r (repmgr.conf) that allows me to solve this problem.<br><br><br>Background=
:<br>- The database is in an Azure IaaS.<br>- The database allows the conne=
ction, but the user drops due to timeout<br>- I can connect to the same ser=
ver and database with their credentials<br>- Firewall allows the connection=
.<br>- the configuration in pg_hba.conf owns the user<br>- user connects th=
rough DBeaver<br>- The database postgreSQL is version 15<br>- user is the o=
wner of the database</div><div><br></div><div>Any contribution is appreciat=
ed.</div></div></blockquote><div><br></div><div>Disconnect during any rando=
m query?</div><div>Disconnect only during a very long-running query?</div><=
div>Disconnect when DBeaver is &quot;just sitting there&quot;, while the us=
er is doing something else?</div><div><br></div></div><span class=3D"gmail_=
signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature">=
<div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t=
 boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div>=
</div></div></div></div></div>

--000000000000b945d506284f2413--