Thread: Statement logging for a particular database

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

"Yuan HOng" <hongyuan1306@gmail.com> writes:
> 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?

This should work:
    ALTER DATABASE foo SET log_statement = true

            regards, tom lane