Re: [GENERAL] PostgreSQL 9.2 Logging

2013-08-22 Thread Jeff Janes
On Wed, Aug 21, 2013 at 12:55 PM, carlosinfl . 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

Re: [GENERAL] PostgreSQL 9.2 Logging

2013-08-21 Thread Luca Ferrari
On Wed, Aug 21, 2013 at 9:55 PM, carlosinfl . wrote: > #debug_print_parse = off > #debug_print_rewritten = off > #debug_print_plan = off > #debug_pretty_print = on > #log_checkpoints = off > #log_connections = off > #log_disconnections = off > The debug_* will log, well, debug information (e.g.,

Re: [GENERAL] PostgreSQL 9.2 Logging

2013-08-21 Thread Raghavendra
> > 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 b

[GENERAL] PostgreSQL 9.2 Logging

2013-08-21 Thread carlosinfl .
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 VA