On Fri, Jul 21, 2017 at 2:11 AM, Nikhil <nikhilsme...@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 <http://openscg.com>* http://openscg.com > > On 21-Jul-2017 11:21 AM, "Andreas Kretschmer" <andr...@a-kretschmer.de> > wrote: > >> On 21 July 2017 07:10:42 GMT+02:00, Nikhil <nikhilsme...@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 >> >
