pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter_e@gmx.net>
To: Stephen Frost <sfrost@snowman.net>
Cc: Fujii Masao <masao.fujii@gmail.com>
Cc: Sawada Masahiko <sawada.mshk@gmail.com>
Cc: David Steele <david@pgmasters.net>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Tatsuo Ishii <ishii@postgresql.org>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Abhijit Menon-Sen <ams@2ndquadrant.com>
Subject: Re: Auditing extension for PostgreSQL (Take 2)
Date: Thu, 07 May 2015 16:42:26 -0400
Message-ID: <554BCE32.7010709@gmx.net> (raw)
In-Reply-To: <20150507142655.GW30322@tamriel.snowman.net>
References: <553938A1.7030707@pgmasters.net>
	<CAD21AoDBt44ABM_0WMketM8bZtqLBMrJpd9RD5tE=Dkr57ft_A@mail.gmail.com>
	<553FA477.5010803@pgmasters.net>
	<CAD21AoCQSGZ5x+sfs4g1x_8Fip60x8ULQFTAGB5XTrKQZvPWPA@mail.gmail.com>
	<CAHGQGwGJnRW69rSL1=tza571_eA44hBeChg-NAVrqQytESgvLg@mail.gmail.com>
	<55443ED1.6070003@gmx.net>
	<20150504190035.GO30322@tamriel.snowman.net>
	<5548095A.1040900@gmx.net>
	<20150505003719.GQ30322@tamriel.snowman.net>
	<5549172B.70005@gmx.net>
	<20150507142655.GW30322@tamriel.snowman.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 5/7/15 10:26 AM, Stephen Frost wrote:
> Auditing is about "what happened" whereas
> statement logging is "log whatever statement the user sent."  pgAudit
> bears this out by logging internal SQL statements and object
> information, unlike what we do with statement logging today.

I don't think this is quite correct.  For example,
log_min_duration_statement logs based on what happened.  log_duration
records what happened.  log_checkpoints records what happened.
log_statement also requires parsing before deciding whether to log.

Generally, "logging" is "what happened".  The stuff in syslog is what
happened on the system.



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (65+ messages)  latest in thread

Message-ID: <554BCE32.7010709@gmx.net>
Permalink:  ../554BCE32.7010709@gmx.net/
Also on:    postgresql.org/message-id/554BCE32.7010709@gmx.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: peter_e@gmx.net, sfrost@snowman.net, masao.fujii@gmail.com, sawada.mshk@gmail.com, david@pgmasters.net, simon@2ndquadrant.com, ishii@postgresql.org, ams@2ndquadrant.com
  Subject: Re: Auditing extension for PostgreSQL (Take 2)
  In-Reply-To: <554BCE32.7010709@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox