Bruce Momjian wrote:
>Andrew Dunstan wrote:
>
>
>>[redirecting to hackers]
>>
>>If you like. I originally just made it happen if log_connections was
>>set, but Neil wanted a separate setting for it. What is the consensus
>>about a name?
>>
>>
>
>log_disconnect?
>
>
Not bad. Maybe for symmetry "log_disconnections" would be better.
Here's what the log lines look like:
for a local connection:
[21340] LOG: session end: duration: 0:00:23.41 user=andrew
database=template1 host=[local]
for a tcp connection:
[21351] LOG: session end: duration: 0:00:20.22 user=andrew
database=template1 host=127.0.0.1 port=33419
for a tcp connection when log_hostname = true:
[21373] LOG: session end: duration: 0:00:02.25 user=andrew
database=template1 host=alphonso port=33421
Do we want to change those too? Maybe "session end: duration:" should be
"disconnection: session time:" or some such.
cheers
andrew
