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 ~