On Fri, Jul 21, 2017 at 8:21 AM, John R Pierce <pierce@xxxxxxxxxxxx> wrote: > if you have per schema logging, where should that get logged ? > > you could implement per DATABASE logging, if you A) add the database name to > the log_prefix, and B) feed your logs to a program that understands this and > splits them out to a log file per database. you could also do this on a > per user basis. but, schema is something very dynamic, its a namespace > within a database, and queries can touch multiiple schemas. Personally, I understand that as logging the query N times, once per schema, if it touches N schemas, making the exercise part of parsing. I think that it would be possible to use the parser hook to achieve that actually, as you need extra lookups for WITH clauses and such. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
