pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedaudit 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>
2007-08-13 14:59 ` Re: Audit Trail Kevin Grittner <Kevin.Grittner@wicourts.gov>
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 05:24 Audit Trail Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
@ 2007-08-13 14:59 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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