Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL Logs

From: "Postgresql" <postgresql(at)troygeek(dot)com>
To: "'Mike G'" <mike(at)thegodshalls(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Logs
Date: 2004-05-28 02:35:36
Message-ID: 20040528023539.D8967D1B17C@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-general
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(at)thegodshalls(dot)com] 
Sent: Thursday, May 27, 2004 10:27 PM
To: Postgresql
Cc: pgsql-general(at)postgresql(dot)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 ~
> 
>  
> 





In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-05-28 04:47:39
Subject: Re: Naive schema questions
Previous:From: Mike GDate: 2004-05-28 02:27:07
Subject: Re: PostgreSQL Logs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group