question

sqluser-0880 avatar image
0 Votes"
sqluser-0880 asked AnuragSharma-MSFT commented

'waittimeout' server parameter in azure database for postgresql ?

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-postgresql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered AnuragSharma-MSFT commented

Hi @sqluser-0880, 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'




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sqluser-0880, I have received the response back from PG and as per them the closest we can get is using statement_timeout only.

Please let me know if this helps.



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


0 Votes 0 ·