Toggle navigation
Type: integer
Default: 60
Min: 1
Max: 600
Unit: seconds (s)
Context: sighup
Restart: false

Maximum time to complete client authentication, in seconds. If a would-be client has not completed the authentication protocol in this much time, the server closes the connection. This prevents hung clients from occupying a connection indefinitely. The default is one minute (1m). This parameter can only be set in the postgresql.conf file or on the server command line.

Recommendations

For production databases, it's important that this value be synchronized with the timeout on the application server side. Most web applications will want a shorter timeout, like 20s.

Comments