Re: Adding ddl audit trigger

From: Lawrence Cohan <LCohan(at)web(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Adding ddl audit trigger
Date: 2011-01-27 22:02:39
Message-ID: 965AA5440EAC094E9F722519E285ACED725C0B9936@WWCEXCHANGE.web.web.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We'll do that - thanks again.

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: January-27-11 3:58 PM
To: Lawrence Cohan
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Adding ddl audit trigger

On Thu, Jan 27, 2011 at 1:47 PM, Lawrence Cohan <LCohan(at)web(dot)com> wrote:
> That should do it for our dev environment however on production systems it would be a little bit harder (quite a few hops/approval/restore) to get to and grep the log files.

Sounds like you need a process to scrub logs and ship them out to
where you can get to them.

Attention:
The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2011-01-27 22:23:52 Re: Problem with restoring from backup on 9.0.2
Previous Message Scott Marlowe 2011-01-27 21:57:34 Re: resizing a varchar column on 8.3.8