Re: Database connection log

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Database connection log
Date: 2018-06-14 14:51:58
Message-ID: 20180614145157.GA99890@elch.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Tiffany Thang (tiffanythang(at)gmail(dot)com):

> Does PostgreSQL keep a log of client connections to the database like
> Oracle's listener.log? I would like to extract information such as how many
> connections are made to the database daily, the IP addresses they
> originated from and the schemas they are connected to. Would it be possible
> to extract the above information in PostgreSQL?

Set "log_connections" to "on":
https://www.postgresql.org/docs/10/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT

Regards,
Christoph

--
Spare Space

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pierre Timmermans 2018-06-14 18:00:39 Re: Database connection log
Previous Message Tiffany Thang 2018-06-14 14:48:05 Database connection log