Re: How can I have 2 completely seperated databases in

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How can I have 2 completely seperated databases in
Date: 2004-02-12 15:35:18
Message-ID: 402B9D36.4010504@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor wrote:

>Last time I looked,
>you couldn't get the database name in the log files to allow for
>mechanical filtering
>

Watch this space.When my log_disconnections patch makes it through the
filter process it will be followed up with a patch that allows tagging
of log lines with a printf-style string.

My current thinking is to provide the following escapes:

%U = user
%D = database
%T = timestamp
%P = pid
%L = session log line number
%C = sessionid cookie (hex encoded session start time + pid)
%S = session start timestamp

and I'm willing to entertain other suggestions.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua Drake 2004-02-12 15:35:22 Re: How can I have 2 completely seperated databases in
Previous Message Tom Lane 2004-02-12 15:30:02 Re: Circular-freelist bug is still there