'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,606 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'

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.