Re: Statement logging for a particular database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Yuan HOng" <hongyuan1306(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Statement logging for a particular database
Date: 2006-12-08 15:23:25
Message-ID: 5129.1165591405@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Yuan HOng" <hongyuan1306(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lonorthern 2006-12-08 15:32:38 unsubscribe
Previous Message Tom Lane 2006-12-08 15:16:53 Re: Should clients warn in case of server version mismatch ?