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: Ozgur Kulu <kuluozgur@gmail.com>
Date: Mon, 2 Dec 2024 20:48:11 +0300
Message-ID: 
 <CAF5PJVwCue3jnc0XdAp5g6BDe+vAO37fQvhpVNQT2Sq_Ana-8g@mail.gmail.com>
Subject: Re: Database disconnection due to timeout
To: Erik Serrano <eserranos@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008ee1a406284d277f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAF5PJVwCue3jnc0XdAp5g6BDe%2BvAO37fQvhpVNQT2Sq_Ana-8g%40mail.gmail.com>
Precedence: bulk

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

Hi Erik,

First of all, check statement_timeout parameter on db side.
secondly, ask the developmet team or middleware team timeout settings.

Regards,

Erik Serrano <eserranos@gmail.com>, 2 Ara 2024 Pzt, 19:34 tarihinde =C5=9Fu=
nu
yazd=C4=B1:

> 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.
>
> Thank you very much for your contributions and help.
> Greetings
>
>
> *Erik R. Serrano Saavedra*
> *Ingeniero de Sistemas Inform=C3=A1ticos*
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi Erik,<div><br></div><div>First of all,=
 check=C2=A0<span style=3D"color:rgb(36,36,36);font-family:source-code-pro,=
Menlo,Monaco,&quot;Courier New&quot;,Courier,monospace;font-size:14px;lette=
r-spacing:-0.308px;white-space:pre;background-color:rgb(249,249,249)">state=
ment_timeout parameter on db side.</span></div><div><font color=3D"#242424"=
 face=3D"source-code-pro, Menlo, Monaco, Courier New, Courier, monospace"><=
span style=3D"font-size:14px;letter-spacing:-0.308px;white-space:pre;backgr=
ound-color:rgb(249,249,249)">secondly, ask the developmet team or middlewar=
e team timeout settings.</span></font></div><div><font color=3D"#242424" fa=
ce=3D"source-code-pro, Menlo, Monaco, Courier New, Courier, monospace"><spa=
n style=3D"font-size:14px;letter-spacing:-0.308px;white-space:pre;backgroun=
d-color:rgb(249,249,249)"><br></span></font></div><div><font color=3D"#2424=
24" face=3D"source-code-pro, Menlo, Monaco, Courier New, Courier, monospace=
"><span style=3D"font-size:14px;letter-spacing:-0.308px;white-space:pre;bac=
kground-color:rgb(249,249,249)">Regards,</span></font></div></div></div><br=
><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D=
"gmail_attr">Erik Serrano &lt;<a href=3D"mailto:eserranos@gmail.com">eserra=
nos@gmail.com</a>&gt;, 2 Ara 2024 Pzt, 19:34 tarihinde =C5=9Funu yazd=C4=B1=
:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.=
8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"lt=
r"><div>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:<br><br>A user drops the connection from =
his console to the replica slave database due to timeout, it is possible th=
at there is a parameter within the configuration file (postgresql.conf) con=
nection (pg_hba.conf) or replica manager (repmgr.conf) that allows me to so=
lve this problem.<br><br><br>Background:<br>- The database is in an Azure I=
aaS.<br>- The database allows the connection, but the user drops due to tim=
eout<br>- I can connect to the same server and database with their credenti=
als<br>- Firewall allows the connection.<br>- the configuration in pg_hba.c=
onf owns the user<br>- user connects through DBeaver<br>- The database post=
greSQL is version 15<br>- user is the owner of the database</div><div><br><=
/div><div>Any contribution is appreciated.</div><div><br></div><div>Thank y=
ou very much for your contributions and help.<br>Greetings</div><div><br></=
div><div><div dir=3D"ltr" class=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 st=
yle=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 N=
ew 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>
</blockquote></div>

--0000000000008ee1a406284d277f--