Re: Can Log filename include database name? - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Can Log filename include database name?
Date
Msg-id cone.1152490979.373306.71862.1000@zoraida.natserv.net
Whole thread Raw
In response to Can Log filename include database name?  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: Re: Procedural language functions across servers
Next
From: Ron St-Pierre
Date:
Subject: Re: Version Discrepancy