Re: Database connection log

Поиск
Список
Период
Сортировка
От Pierre Timmermans
Тема Re: Database connection log
Дата
Msg-id 117841277.5046710.1528999239564@mail.yahoo.com
обсуждение исходный текст
Ответ на Database connection log  (Tiffany Thang <tiffanythang@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Database connection log
Следующее
От: George Woodring
Дата:
Сообщение: Can I disable sslcert/sslkey in pg_service.conf?