Re: [GENERAL] Logging at schema level - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] Logging at schema level
Date
Msg-id e7732b70-94d9-92c4-fe75-8bd56665b8f3@a-kretschmer.de
Whole thread Raw
In response to Re: [GENERAL] Logging at schema level  (Nikhil <nikhilsmenon@gmail.com>)
List pgsql-general

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@a-kretschmer.de
> <mailto:andreas@a-kretschmer.de>> wrote:
>
>     On 21 July 2017 07:10:42 GMT+02:00, Nikhil <nikhilsmenon@gmail.com
>     <mailto: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
>

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



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Logging at schema level
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Streaming Replication archive_command is really needed?