PostgreSQL 9.2 Logging

From: "carlosinfl (dot)" <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL 9.2 Logging
Date: 2013-08-21 19:55:05
Message-ID: CAAQLLO61gxKxOTLX82c7_PRG0=KsCkue5PmQXmKq4te2fR7RJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 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?

#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - When to Log -

^^^^

Not sure what to change here...

# - What to Log -

#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

Do you PG veterans have any log change recommendations / changes I can
make which would help me understand what my system is doing? I don't
want to log every little thing possible and choke my disk with
informative logging but just basic 'what's going on' logs would be
awesome.

Thanks for any help!

--
Carlos Mennens

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Prabhjot Sheena 2013-08-21 20:28:25 No caching sql query
Previous Message Lonni J Friedman 2013-08-21 18:23:26 Re: WAL Replication Working but Not Working