Database audit / Associating a statement with connection

From: Ben Kim <bkim(at)coe(dot)tamu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database audit / Associating a statement with connection
Date: 2005-02-25 18:24:08
Message-ID: Pine.GSO.4.10.10502251150350.9049-100000@edsun.coe.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I have some questions and would like help.

(1) Audit practice
Is there a good source of information about audit for postgresql
databases?

Specifically I'd like some advice on these:

(2) Associating a statement with a database connection

I'm logging statements and connections, but it seems the statement is not
associated with the connection in the log.

- log_connections = true
- log_statement = true

connection received: host=128.91.23.43 port=35644
query: SELECT ID, ....

Is there a way to associate them so I know which statement came from which
connection?

(3) Associating a web connection with a database connection

Also, if I have a web frontend for the database, what would be the best
practice to associate a statement with a particular web client IP?

For example, I have in the postgresql log
connection received: host=128.91.23.43 port=35644
where 128.91.23.43 is my web server.

The web server log records all client connections and accessed pages, but
I don't have a good method of associating the web client connections with
the database client connections.

I'd appreciate any pointers.

Regards,

Ben Kim
Database Developer/Systems Administrator
434E Harrington Tower / College of Education
Texas A&M University

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-02-25 19:11:01 Re: Database audit / Associating a statement with connection
Previous Message Naomi Walker 2005-02-25 17:50:16 Re: Postgresql on Solaris versus Linux