Thread: PostgreSQL Logs

PostgreSQL Logs

From
"Postgresql"
Date:

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 ~

 

Re: PostgreSQL Logs

From
Mike G
Date:
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 ~
>
>
>

Re: PostgreSQL Logs

From
"Postgresql"
Date:
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 ~
>
>
>