Postgres Pro
Downloads
Home   >   mailing lists

Re: Database connection log - Mailing list pgsql-general

From Pierre Timmermans
Subject Re: Database connection log
Date
Msg-id 117841277.5046710.1528999239564@mail.yahoo.com
Whole thread Raw
In response to Database connection log  (Tiffany Thang <tiffanythang@gmail.com>)
List pgsql-general
Tree view
I believe that you can achieve what you want with the following configuration parameters: log_connections and log_line_prefix 






Regards, Pierre


On Thursday, June 14, 2018, 4:48:54 PM GMT+2, Tiffany Thang <tiffanythang@gmail.com> wrote:


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.

pgsql-general by date:

Previous
From: Christoph Moench-Tegeder
Date:
Subject: Re: Database connection log
Next
From: George Woodring
Date:
Subject: Can I disable sslcert/sslkey in pg_service.conf?