I believe that you can achieve what you want with the following configuration
parameters: log_connections and log_line_prefix
PostgreSQL: Documentation: 10: 19.8. Error Reporting and Logging
|
|
|
| | |
|
|
|
| |
PostgreSQL: Documentation: 10: 19.8. Error Reporting and Logging
|
|
|
Regards, Pierre
On Thursday, June 14, 2018, 4:48:54 PM GMT+2, Tiffany Thang
<[email protected]> 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.
