Database connection log

From: Tiffany Thang <tiffanythang(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Database connection log
Date: 2018-06-14 14:48:05
Message-ID: CAB_W-NM7QUrLLHKY0=EzKDKwP+HFmOW-wZ76dbwE004Lbaw+mw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
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?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2018-06-14 14:51:58 Re: Database connection log
Previous Message Alvaro Herrera 2018-06-14 14:37:44 Re: Impact of multixact "members" limit exceeded