Re: Statement logging for a particular database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Statement logging for a particular database
Дата
Msg-id 5129.1165591405@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Statement logging for a particular database  ("Yuan HOng" <hongyuan1306@gmail.com>)
Список pgsql-admin
Дерево обсуждения 
"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 по дате отправления: