Re: PostgreSQL 9.2 Logging

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: PostgreSQL 9.2 Logging
Дата
Msg-id CAMkU=1xG6YzU-48Q1MAZ8fZhcALHVrUhvx_Fa2-9pW4cFjYdbQ@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL 9.2 Logging  ("carlosinfl ." <carlos.mennens@gmail.com>)
Список pgsql-general
On Wed, Aug 21, 2013 at 12:55 PM, carlosinfl . <carlos.mennens@gmail.com> wrote:
> I'm trying to understand how 9.2.4 logs common tasks and info in
> CentOS 6.4 Linux. It appears everything is stored in
> /var/lib/pgsql9/data/pg_log/postgresql-%a.log
>
> My issue is the logging information is fairly missing / light. I only
> see auth failures and nothing more. I tried to perform my 1st VACUUM
> command on my database and I was hoping to see something in the logs
> showing it PASSED / FAILED or even was manually initiated by a
> superuser role but I see nothing...

I'm not sure why that is of interest.  If you invoked the command from
psql interactively, you get the results on your screen.  If you do it
in a script, you can arrange to log the results from that script.


> I don't need to log every single verbose thing this database server
> does but I would expect something like a VACUUM command would be
> warranted to be logged, no?


Fast running manually invoked vacuums seem like one of the least
interesting things to log to me.  I can see wanting to log slow
vacuums, but why just vacuum and not all slow statements?  (Which you
can already do)

But it does seem like maybe an option of 'util' for log_statement
would be reasonable to have.

Cheers,

Jeff


В списке pgsql-general по дате отправления:

Предыдущее
От: "Nicholson, Brad (Toronto, ON, CA)"
Дата:
Сообщение: Temp files on Commit
Следующее
От: Don Parris
Дата:
Сообщение: Re: Locale Issue