471,083 Members | 1,207 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

PostgreSQL Logs

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 ~


Nov 23 '05 #1
2 2026
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

Nov 23 '05 #2
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

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by My Internet | last post: by
11 posts views Thread by Errol Neal | last post: by
19 posts views Thread by Alex Madon | last post: by
11 posts views Thread by Sezai YILMAZ | last post: by
1 post views Thread by phil campaigne | last post: by
6 posts views Thread by Jean-Guillaume LALANNE | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.