Thread: 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 ~
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/static/runtime-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 ~ > > >
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:mike@thegodshalls.com] Sent: Thursday, May 27, 2004 10:27 PM To: Postgresql Cc: pgsql-general@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/static/runtime-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 ~ > > >