SEO

#1 (**permalink**) 04-10-2008, 06:54 AM

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#2 (**permalink**) 04-10-2008, 06:54 AM

"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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Statement logging for a particular database