[ADMIN] Audit Log Destination

2009-05-20 Thread Arnold, Sandra
One of my security controls is to audit events.  I don't have a problem
on how to do that.  However, another control is for all functionality of
the PostgreSQL database to cease or stall if the directory that contains
the audit logs is full.  What happens to PostgreSQL if any of the log
directories are full and unable to have anything else written to it?  I
have looked and cannot find anything that will tell me what happens.
 
Thanks,

Sandra Arnold
Sr. DBA
DOE/OSTI


Re: [ADMIN] Audit Log Destination

2009-05-20 Thread Peter Eisentraut
On Wednesday 20 May 2009 23:51:53 Arnold, Sandra wrote:
 One of my security controls is to audit events.  I don't have a problem
 on how to do that.  However, another control is for all functionality of
 the PostgreSQL database to cease or stall if the directory that contains
 the audit logs is full.  What happens to PostgreSQL if any of the log
 directories are full and unable to have anything else written to it?  I
 have looked and cannot find anything that will tell me what happens.

PostgreSQL doesn't have the concept of an audit log. So perhaps you can 
explain exactly which functionality you are using for that purpose; then we 
might figure out what happens when the disk is full.

In principle, however, you can try this out yourself, by creating a limited-
size partition and pointing your log there.  That might give you a better 
feeling for what exactly will happen.

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