Statement logging for a particular database

From: "Yuan HOng" <hongyuan1306(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Statement logging for a particular database
Date: 2006-12-08 09:43:33
Message-ID: 91320d220612080143u60bb5a94ne7f6703b67e9516@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am running PostgreSQL 7.4, and I'd like to turn on statement logging
for only one database rather than the server instance.

The log_statement = true option doesn't distinguish between databases.
Is there another option? In 8.1 one can put the database name into the
log string for filtering, but this doesn't seem to be available in
7.4.

--
Hong Yuan

大管家网上建材超市
装修装潢建材一站式购物
http://www.homemaster.cn

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ankit.mehrotra 2006-12-08 09:44:53 Re: problem in logging into database
Previous Message Morten Andersen 2006-12-08 09:42:27 Re: Recovery plan for DRDB setup - recovery tool