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