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 ~
>
>
>