PostgreSQL 9.2 Log Help

From: "carlosinfl (dot)" <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PostgreSQL 9.2 Log Help
Date: 2013-08-21 19:22:00
Message-ID: CAAQLLO7GaC8Mx+Yu4WUZgTw=RxUTfcehH2xBXUZ57Tugcxnnkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I performed my first VACUUM today on my database. I'm trying to learn
PostgreSQL and learn about basic DBA tasks that need to be performed
regularly so I can eventually automate this with Cron in Linux.

I'm currently running PostgreSQL 9.2.4 on Amazon Linux (RHEL based):

Is there a way to control what gets logged in
/var/lib/pgsql9/data/pg_log/postgresql-{$DAY}.log

When I view my log for today (Wednesday) after running VACUUM on my
database, I see nothing mentioned or noted in my logs as to if this
ran / failed / passed / what the heck happened...it's like nothing is
getting logged except start up status and auth failures:

[root(at)db1 pg_log]# cat postgresql-Wed.log

FATAL: password authentication failed for user "postgres"
FATAL: password authentication failed for user "carlos"
FATAL: password authentication failed for user "carlos"

[root(at)db1 pg_log]#

Can someone help me understand how things / tasks / commands get
logged in the database and where that would be?

Thanks!

--
Carlos Mennens

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Amit Langote 2013-08-22 03:28:13 Re: PostgreSQL 9.2 Log Help
Previous Message Tom Lane 2013-08-20 19:30:24 Re: Problem with backing up a large database