Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to set connection timeout value for pgAdmin?

I am using pgAdmin to connect remotely to my database as phpPgAdmin is a bit limited in its features. Only problem is if I leave the SQL window open without running a query for a few minutes, then it says I need to reconnect.

Is this a setting I need to change in my database to keep remote connections alive for longer or is it a pgAdmin setting?

like image 451
Kevin Orriss Avatar asked Jun 06 '14 21:06

Kevin Orriss


1 Answers

It is client setting. You need specify connect_timeout in your config file. 29.1. Database Connection Control Functions 29.14. The Connection Service File

like image 177
Ivan Burlutskiy Avatar answered Oct 06 '22 15:10

Ivan Burlutskiy