Re: Can Log filename include database name?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can Log filename include database name?
Date: 2006-07-10 00:22:59
Message-ID: cone.1152490979.373306.71862.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron St-Pierre 2006-07-10 03:13:40 Re: Version Discrepancy
Previous Message Mark Morgan Lloyd 2006-07-09 21:31:42 Re: Procedural language functions across servers