Re: Logging at schema level

Am 21.07.2017 um 08:11 schrieb Nikhil:
> Schema = tenant. So basically tenant level logging.
>
> On 21-Jul-2017 11:21 AM, "Andreas Kretschmer" <andreas(at)a-kretschmer(dot)de
> <mailto:andreas(at)a-kretschmer(dot)de>> wrote:
>
> On 21 July 2017 07:10:42 GMT+02:00, Nikhil <nikhilsmenon(at)gmail(dot)com
> <mailto: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
>

Logging can mean 'logging of errors' or 'logging of data changes'. For
the latter i'm thinking on logical replication,
https://blog.2ndquadrant.com/why-logical-replication/

(Please don't top-post)

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com