Information
Enabling the log_disconnections setting logs the end of each session, including session duration. This parameter cannot be changed after session start.
Rationale:
PostgreSQL does not maintain the beginning or ending of a connection internally for later review. It is only by enabling the logging of these that one can examine connections for failed attempts, 'over long' duration, or other anomalies.
Solution
Execute the following SQL statement(s) to enable this setting:
postgres=# alter system set log_disconnections = 'on';
ALTER SYSTEM
postgres=# select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)
Default Value:
off