10

I have read the article listed here:

How to set connection timeout value for pgAdmin?

many times, but I still have no idea where one sets the config parameter for connection_timeout. I am connecting from a local host to a local host, so there should be no real problems with keep alives.

I would like to know the path to:

  1. The server setting if that is where it needs to be set
  2. the location for a client config (if that is where it is set)
  3. What the exact values that have to be put in for that.

I see others are also confused:

https://dba.stackexchange.com/questions/97534/is-there-a-timeout-option-for-remote-access-to-postgresql-database

Community
  • 1
  • 1
Dr.YSG
  • 7,171
  • 22
  • 81
  • 139
  • http://dba.stackexchange.com/questions/61193/how-to-edit-postgresql-conf-with-pgadmin – Ankur Jyoti Phukan Mar 28 '17 at 14:48
  • @AnkurJyotiPhukan yes, that is the way to get to the configuration. But what parameter does one change in the postgresql.conf ? And what does one set it to? And why is this a server-wide setting, and not a client setting? – Dr.YSG Mar 29 '17 at 13:54
  • i can give the last question answer , because if it is clientside there is a chance that client connection will never time out .. therefore this control is with the server so that it can dynamicaly adjust the timeout time according to the stress on server – Ankur Jyoti Phukan Mar 29 '17 at 14:34
  • at last find the document https://jdbc.postgresql.org/documentation/head/connect.html – Ankur Jyoti Phukan Mar 29 '17 at 14:38
  • @AnkurJyotiPhukan, FYI, PGADMIN 4 no longer has a TOOLS-> Server Config – Dr.YSG Mar 29 '17 at 17:07
  • i think i can't help you ... – Ankur Jyoti Phukan Mar 29 '17 at 17:39
  • @Dr.YSG Can you ask on one of the Postgres mailing lists? Maybe the developers and other experienced users can help out. There is anecdotal evidence that this feature doesn't always help. – Colin 't Hart Aug 29 '17 at 17:51
  • any progress on this? I currently have a timeout to my db using pgadmin4 and nginx proxy - but everything else works fine. Is this an nginx conf? – Jared Nov 21 '18 at 06:09

1 Answers1

0

I don't know if this is useful. It is from the documentation:

"The [runtime] configuration settings are stored using the QSettings class in Qt, which will use
- an INI file on Unix systems (~/.config/pgadmin/pgadmin4.conf)
- a plist file on Mac OS X (~/Library/Preferences/org.pgadmin.pgadmin4.plist)
- and the registry on Windows (HKEY_CURRENT_USER\Software\pgadmin\pgadmin4)."

table

The documentation also mentions 3 other configuration files in the section immediately preceding this one.

John
  • 1,018
  • 12
  • 19