public inbox for [email protected]help / color / mirror / Atom feed
Database disconnection due to timeout 5+ messages / 3 participants [nested] [flat]
* Database disconnection due to timeout @ 2024-12-02 16:34 Erik Serrano <[email protected]> 0 siblings, 2 replies; 5+ messages in thread From: Erik Serrano @ 2024-12-02 16:34 UTC (permalink / raw) To: Pgsql-admin <[email protected]> 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áticos* ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database disconnection due to timeout @ 2024-12-02 17:48 Ozgur Kulu <[email protected]> parent: Erik Serrano <[email protected]> 1 sibling, 1 reply; 5+ messages in thread From: Ozgur Kulu @ 2024-12-02 17:48 UTC (permalink / raw) To: Erik Serrano <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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 <[email protected]>, 2 Ara 2024 Pzt, 19:34 tarihinde şunu yazdı: > 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áticos* > > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database disconnection due to timeout @ 2024-12-02 18:15 Erik Serrano <[email protected]> parent: Ozgur Kulu <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Erik Serrano @ 2024-12-02 18:15 UTC (permalink / raw) To: Ozgur Kulu <[email protected]>; +Cc: Pgsql-admin <[email protected]> Thank you for your help! *Erik R. Serrano Saavedra* El lun, 2 dic 2024 a las 14:48, Ozgur Kulu (<[email protected]>) escribió: > 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 <[email protected]>, 2 Ara 2024 Pzt, 19:34 tarihinde şunu > yazdı: > >> 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áticos* >> >> ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database disconnection due to timeout @ 2024-12-02 20:10 Ron Johnson <[email protected]> parent: Erik Serrano <[email protected]> 1 sibling, 1 reply; 5+ messages in thread From: Ron Johnson @ 2024-12-02 20:10 UTC (permalink / raw) To: Pgsql-admin <[email protected]> On Mon, Dec 2, 2024 at 11:34 AM Erik Serrano <[email protected]> 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! ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database disconnection due to timeout @ 2024-12-02 20:43 Erik Serrano <[email protected]> parent: Ron Johnson <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Erik Serrano @ 2024-12-02 20:43 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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áticos* El lun, 2 dic 2024 a las 17:10, Ron Johnson (<[email protected]>) escribió: > On Mon, Dec 2, 2024 at 11:34 AM Erik Serrano <[email protected]> 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! > ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-12-02 20:43 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-12-02 16:34 Database disconnection due to timeout Erik Serrano <[email protected]> 2024-12-02 17:48 ` Ozgur Kulu <[email protected]> 2024-12-02 18:15 ` Erik Serrano <[email protected]> 2024-12-02 20:10 ` Ron Johnson <[email protected]> 2024-12-02 20:43 ` Erik Serrano <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox