Re: Logging at schema level

On Fri, Jul 21, 2017 at 2:11 AM, Nikhil <nikhilsmenon(at)gmail(dot)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 <http://openscg.com>*
http://openscg.com

>
> On 21-Jul-2017 11:21 AM, "Andreas Kretschmer" <andreas(at)a-kretschmer(dot)de>
> wrote:
>
>> On 21 July 2017 07:10:42 GMT+02:00, Nikhil <nikhilsmenon(at)gmail(dot)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
>>
>