PostgreSQL Logs

[Postgresql]

What logs does postgresql produce?

1) It has transaction logs. Can it log connections? Are there other
logs?

2) When I start postgresql it outputs log messages to the console.
Does this also log anywhere else?

What I'm trying to do is find all the postgresql log files and then find a
way to load them into a database and then have a program scan that data and
look for anything out of the ordinary or to do reporting on the logs (like
how many connections per hour, per day, etc).

Thank you!

~ T r o y ~

[Mike G]

Yes to the first two questions under number 1. Not sure what you are looking for on the last one.

Yes to number 2 if you configure it correctly although I don't know if it can write to a file and screen at the same time.

Open the postgresql.conf file.

This page in the docs might help.

http://www.postgresql.org/docs/7.4/s...me-config.html
On Thu, May 27, 2004 at 05:39:19PM -0400, Postgresql wrote:

What logs does postgresql produce?

1) It has transaction logs. Can it log connections? Are there other
logs?

2) When I start postgresql it outputs log messages to the console.
Does this also log anywhere else?

What I'm trying to do is find all the postgresql log files and then find a
way to load them into a database and then have a program scan that data and
look for anything out of the ordinary or to do reporting on the logs (like
how many connections per hour, per day, etc).

Thank you!

~ T r o y ~

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Postgresql]

Basically, I'm looking for information on logging connections (who's
connecting and when), what the users are doing when connected (creating
tables, updating data, etc), and if there are any system messages (like when
the postgresql server is started, stopped, if it has problems, etc).
Thanks!

-----Original Message-----
From: Mike G [mailto:mi**@thegodshalls.com]
Sent: Thursday, May 27, 2004 10:27 PM
To: Postgresql
Cc: pg***********@postgresql.org
Subject: Re: [GENERAL] PostgreSQL Logs

Yes to the first two questions under number 1. Not sure what you are
looking for on the last one.

Yes to number 2 if you configure it correctly although I don't know if it
can write to a file and screen at the same time.

Open the postgresql.conf file.

This page in the docs might help.

http://www.postgresql.org/docs/7.4/s...me-config.html
On Thu, May 27, 2004 at 05:39:19PM -0400, Postgresql wrote:

What logs does postgresql produce?

1) It has transaction logs. Can it log connections? Are there other
logs?

2) When I start postgresql it outputs log messages to the console.
Does this also log anywhere else?

What I'm trying to do is find all the postgresql log files and then find a
way to load them into a database and then have a program scan that data and look for anything out of the ordinary or to do reporting on the logs (like
how many connections per hour, per day, etc).

Thank you!

~ T r o y ~

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster