Logging Help Needed

From: "Oakley " <oakerz(at)eudoramail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging Help Needed
Date: 2000-07-17 11:54:11
Message-ID: CIPAEAPADFJEAAAA@shared1-mail.whowhere.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Being somewhat new to the databasing world, I have done quite a bit of research on the different DB's available and decided to go with Postgres. I am working on a system that has to have 3rd level normalization.. As one might be able to tell since I am emailing all of you for your help, I am having a problem... I cant get it to log anything other than when the DB comes up, or goes down...

When I did the configure, I did it with
--enable-syslog and with the --without-CXX
options. I read the online docs and created a
file in the /usr/local/pgsql/data directory
called postgresql.conf, and put in the options
I wanted, those being:

# --------
syslog = 2
debug_level = 2
log_connections = yes
log_timestamp = yes
port = 5432
# --------

(I have seen notes in the mailing list archives that logging to syslog is bad - opinions/insight on this?)

As you might be able to tell from the options
above, I am wanting to keep track of connections
and the time that people connect up to the DB
and what they execute, etc...

Can anyone help? I would greatly appreciate it!

Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rogers 2000-07-17 13:04:05 Trouble with RPM
Previous Message Jesus Aneiros 2000-07-17 11:10:02 Re: urgent help on function/trigger