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

From Jaime Casanova
Subject Re: Can Log filename include database name?
Date
Msg-id c2d9e70e0607091415y5b2c96bnc0392dcc0609cb0f@mail.gmail.com
Whole thread Raw
In response to Can Log filename include database name?  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
On 7/7/06, Francisco Reyes <lists@stringsutils.com> wrote:
> I am currently using a log with the file name format:
> log_filename = 'postgresql-%Y-%m.log'
>
> Is there any way to change the filename do start witht he database name?
>
> For now just added to add the database name to each line, but it would be
> usefull to have each DB written to it's own file. Or even better to be able
> to specify on a per database basis whether to log or not.
>

so you want a different logfile for every database you connect to?
where do you will log database shared operations like autovacuum, role
creation, maybe even a database creation, tablespace creation, etc...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: Re: Procedural language functions across servers
Next
From: Mark Morgan Lloyd
Date:
Subject: Re: Procedural language functions across servers