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 ~ > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
