Search Postgresql Archives

Database connection log

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Database connection log
From: Tiffany Thang <tiffanythang@xxxxxxxxx>
Date: Thu, 14 Jun 2018 10:48:05 -0400

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Database connection log
  - From: Pierre Timmermans
- Re: Database connection log
  - From: Christoph Moench-Tegeder

Prev by Date: Re: Impact of multixact "members" limit exceeded
Next by Date: Re: Database connection log
Previous by thread: Append only replication over intermittent links (with local only delete?)
Next by thread: Re: Database connection log
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux