Dealing with idle connections in Azure Postgres

timeout-postgres.md

This changes the postgresql idle connection timeout on Azure Postgres: ref: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/connection-handling-best-practice-with-postgresql/ba-p/790883

• idle in transaction
• idle

1. Connection to psql db on azure

$ psql -h HOST -p 5432 -U USER DBNAME --set=sslmode=require

2. Change idle transaction connections (600000 = 10m)

DBNAME=> alter database DBNAME set statement_timeout = 600000;

3. Change idle connections (300000 = 5m)

DBNAME=> alter database DBNAME set idle_in_transaction_session_timeout = 300000;