pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
audit trail
6+ messages / 4 participants
[nested] [flat]

* audit trail
@ 2003-05-22 18:46  Alex.H.Pollock@WellsFargo.COM
  0 siblings, 0 replies; 6+ messages in thread

From: Alex.H.Pollock@WellsFargo.COM @ 2003-05-22 18:46 UTC (permalink / raw)
  To: pgsql-admin

Does anyone know of a good way to create a continuous audit trail with no
gaps within PostgreSQL that can tell who has done what at what time?

Thanks.

Alex Pollock
WFSC Data Services District
Database Administration




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: audit trail
@ 2003-05-22 21:02  Larry Rosenman <ler@lerctr.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Larry Rosenman @ 2003-05-22 21:02 UTC (permalink / raw)
  To: Alex.H.Pollock@WellsFargo.COM; pgsql-admin

see the thread I had on the SQL list last week.  Joe Conway posted a 
WONDERFUL solution
using contrib/dblink.

LER


--On Thursday, May 22, 2003 11:46:24 -0700 Alex.H.Pollock@WellsFargo.COM 
wrote:

> Does anyone know of a good way to create a continuous audit trail with no
> gaps within PostgreSQL that can tell who has done what at what time?
>
> Thanks.
>
> Alex Pollock
> WFSC Data Services District
> Database Administration
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: audit trail
@ 2003-05-22 21:57  Alex.H.Pollock@WellsFargo.COM
  0 siblings, 0 replies; 6+ messages in thread

From: Alex.H.Pollock@WellsFargo.COM @ 2003-05-22 21:57 UTC (permalink / raw)
  To: ler@lerctr.org; pgsql-admin

Thanks Larry!  

I was wondering whether the Statistics Collector in section 10.2 of the
Admin manual might be a way to not only create an audit trail of insert,
update, and delete, but all sql activity and who is doing it. Could the
pg_stat_activity view or the access functions be used for this?  But maybe
this would not create a continuous stream, and activity would be missed?

Alex Pollock
WFSC Data Services District
Database Administration



-----Original Message-----
From: Larry Rosenman [mailto:ler@lerctr.org]
Sent: Thursday, May 22, 2003 2:02 PM
To: Alex.H.Pollock@WellsFargo.COM; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] audit trail


see the thread I had on the SQL list last week.  Joe Conway posted a 
WONDERFUL solution
using contrib/dblink.

LER


--On Thursday, May 22, 2003 11:46:24 -0700 Alex.H.Pollock@WellsFargo.COM 
wrote:

> Does anyone know of a good way to create a continuous audit trail with no
> gaps within PostgreSQL that can tell who has done what at what time?
>
> Thanks.
>
> Alex Pollock
> WFSC Data Services District
> Database Administration
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: audit trail
@ 2003-05-22 22:08  Larry Rosenman <ler@lerctr.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Larry Rosenman @ 2003-05-22 22:08 UTC (permalink / raw)
  To: Alex.H.Pollock@WellsFargo.COM; pgsql-admin



--On Thursday, May 22, 2003 14:57:44 -0700 Alex.H.Pollock@WellsFargo.COM 
wrote:

> Thanks Larry!
>
> I was wondering whether the Statistics Collector in section 10.2 of the
> Admin manual might be a way to not only create an audit trail of insert,
> update, and delete, but all sql activity and who is doing it. Could the
> pg_stat_activity view or the access functions be used for this?  But maybe
> this would not create a continuous stream, and activity would be missed?
I don't know, but if you find out, I'm all eyes.

LER


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Audit Trail
@ 2007-08-13 05:24  Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Khan, Mahmood Ahram @ 2007-08-13 05:24 UTC (permalink / raw)
  To: pgsql-admin; +Cc: tgl@sss.pgh.pa.us

Hi All,

 

As I want to do audit on some tables for Insert Update & Delete. So I am
trying to create a function. 

To enable the auditing I need to create this function which I am unable
to & the error below.

Can anybody help with this. Or any documentation link for this
particular function. I am using Postgres 8.2.4 & Linux kernel 2.6.9

 

 

 

 

 

Thanks & Regards

 

M.AHRAM KHAN

 

 

Attachments:

image002.jpg (image/jpeg, 19.2K) download view image
^ permalink raw reply [nested|flat] 6+ messages in thread

* Re: Audit Trail
@ 2007-08-13 14:59  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Kevin Grittner @ 2007-08-13 14:59 UTC (permalink / raw)
  To: Mahmood Ahram Khan <Mahmood.Khan@in.unisys.com>; pgsql-admin; +Cc: tgl@sss.pgh.pa.us

>>> On Mon, Aug 13, 2007 at 12:24 AM, in message
<D566E8CF3538B54D95B925CB69CB4D2A060DB168@inblr-exch1.eu.uis.unisys.com>,
"Khan, Mahmood Ahram" <Mahmood.Khan@in.unisys.com> wrote: 
> To enable the auditing I need to create this function which I am unable
> to & the error below.
 
Add a line like this after you include the PostgreSQL .h files:
 
PG_MODULE_MAGIC;
 
I was unable to quote the actual error in my reply.
Try a different way to show it next time, please.
 
-Kevin
 





^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2007-08-13 14:59 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-22 18:46 audit trail Alex.H.Pollock@WellsFargo.COM
2003-05-22 21:02 Re: audit trail Larry Rosenman <ler@lerctr.org>
2003-05-22 21:57 Re: audit trail Alex.H.Pollock@WellsFargo.COM
2003-05-22 22:08 Re: audit trail Larry Rosenman <ler@lerctr.org>
2007-08-13 05:24 Audit Trail Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
2007-08-13 14:59 ` Re: Audit Trail Kevin Grittner <Kevin.Grittner@wicourts.gov>

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