Jaime Casanova writes:
> so you want a different logfile for every database you connect to?
An option to specify a log for database.
> where do you will log database shared operations like autovacuum, role
> creation, maybe even a database creation, tablespace creation, etc...
In a global logfile.
Simmilar with what Apache does for virtual domains.
You can specify a log for a virtual domain, and you can also specify a
default/global log file.
Perfects example of where this would be usefull.
Say you have several production databases that work great. You start
developing a new system with a new database and you want to keep an eye on
the performance of the queries for this new system. Right now this would
mean turning on loggin for all of the DBs.. even though you only want to
keep tabs in a single DB.