Postgres Pro
Downloads
Home   >   mailing lists

Re: Statement logging for a particular database - Mailing list pgsql-admin

From Tom Lane
Subject Re: Statement logging for a particular database
Date
Msg-id 5129.1165591405@sss.pgh.pa.us
Whole thread Raw
In response to Statement logging for a particular database  ("Yuan HOng" <hongyuan1306@gmail.com>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Should clients warn in case of server version mismatch ?
Next
From: lonorthern@comcast.net
Date:
Subject: unsubscribe