'waittimeout' server parameter in azure database for postgresql ?

sql user 86 Reputation points
2021-07-05T04:03:31.91+00:00

Team,

Do we have 'waittimeout' server parameter in azure database for postgresql (single server) just like how we have on azure mysql PAAS ???? . if so, what is it?? I would like to change this value on azure for an connection related intermittent drops due to idle sessions.

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,571 Reputation points
    2021-07-05T07:37:05.167+00:00

    Hi @sql user , welcome to Microsoft Q&A forum.

    Currently we don't have the parameter 'wait_timeout' available in Azure PostgreSQL Database, however we have below parameters related to timeout that can be set. Please check if they meet your requirements:

    1. idle_in_transaction_session_timeout: Sets the maximum allowed duration of any idling transaction. Unit is ms.
    2. statement_timeout: Sets the maximum allowed duration (in milliseconds) of any statement.

    I have also reached out to product team to check if there is any way we can achieve this and will get back based on their response.

    ----------

    If answer helps, you can mark it 'Accept Answer'