Re: Database connection log

2018-06-14 Thread Pierre Timmermans
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 |

Re: Database connection log

2018-06-14 Thread Christoph Moench-Tegeder
## Tiffany Thang (tiffanyth...@gmail.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 the