Re: [GENERAL] Logging at schema level

Поиск
Список
Период
Сортировка
От Scott Mead
Тема Re: [GENERAL] Logging at schema level
Дата
Msg-id CAKq0gv+OPuyVRrM5j7eGDfZ=wR=k=qX5FJCzqT_6CYDqGfek6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Logging at schema level  (Nikhil <nikhilsmenon@gmail.com>)
Список pgsql-general


On Fri, Jul 21, 2017 at 2:11 AM, Nikhil <nikhilsmenon@gmail.com> wrote:
Schema = tenant. So basically tenant level logging. 

If each tenant uses a separate user, you could parse this by that user.  You can't separate the logs by user, but, you could use a tool like pgBadger to parse reports for each individual user (tenant) in the system and present the logs that way:

From: https://github.com/dalibo/pgbadger
....
   -u | --dbuser username : only report on entries for the given user.
 ....

--
Scott Mead
Sr. Architect
OpenSCG

On 21-Jul-2017 11:21 AM, "Andreas Kretschmer" <andreas@a-kretschmer.de> wrote:
On 21 July 2017 07:10:42 GMT+02:00, Nikhil <nikhilsmenon@gmail.com> wrote:
>Hello,
>
>I am using postgresql schema feature for multi-tenancy. can we get
>postgresql logs at schema level. Currently it is for the whole database
>server (pg_log)
>

What do you want to achieve? Logging of data-changes per tenant?

Regards, Andreas.


--
2ndQuadrant - The PostgreSQL Support Company




В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] Logging at schema level
Следующее
От: Jordan Gigov
Дата:
Сообщение: [GENERAL] pg_restore misuse or bug?