PostgreSQL Discussion - Isolate Logs

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Isolate Logs

Mag Gam

2005-12-23, 1:23 pm

Is it possible to isolate logging for each individual database?
For example, lets say I have 3 databases: db1, db2, db3. And I want to
log db activity (statements, login/logout, etc..) db1, db2, db3 like
$PGDATA/db1, $PGDATA/db2, $PGDATA/db3, respectively.

Currently everything is logged in $PGDATA/pg_log

TIA

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links