Graham Leggett <minfrin@sharp.fm> writes:
> Does postgresql have an access log where the lifetime of database
> connections are tracked? Specifically tracking when the client
> connected, and how long the client stayed connected for.
See log_connections and log_disconnections. You probably want to
add PID to log_line_prefix, too, so that you can associate different
log entries for the same session.
regards, tom lane