From: Joshua D. Drake <jd@commandprompt.com>
To: Arnold, Sandra <ArnoldS@osti.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What happens when PostgreSQL fails to log to SYSLOG
Date: Tue, 10 Jul 2012 13:31:24 -0700
Message-ID: <4FFC911C.4010107@commandprompt.com> (raw)
In-Reply-To: <54E5385D47A89542BC678F5426799F3905261D424F@OSTIEX01.osti.gov>
References: <54E5385D47A89542BC678F5426799F3905261D424F@OSTIEX01.osti.gov>
On 07/10/2012 01:08 PM, Arnold, Sandra wrote:
> I am trying to find out what PostgreSQL does when it cannot write to its
> SYSLOG file, whether it is permissions or the file system where the log
> resides is full is the problem.
PostgreSQL doesn't write to a SYSLOG file. It sends it to the syslog
daemon. (if you are indeed using syslog)
> Does PostgreSQL stall, does it rollback
> the transaction it cannot log to the SYSLOG, or does it continue on as
> if there is not an issue?
This is a non-issue in terms of transactions and operations.
> I am writing Security controls and since I am
> using the SYSLOG for auditing purposes and I need to document what
> happens in case there was a failure in writing to the SYSLOG. For
> instance, Oracle rollbacks any transactions that are being audited it
> cannot write to its audit logs. Just want to know what PostgreSQL does.
>
You should probably look at tablelog for auditing. It automates it.
Syslog is not really a good way to handle that.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
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-admin@postgresql.org
Cc: jd@commandprompt.com, ArnoldS@osti.gov
Subject: Re: What happens when PostgreSQL fails to log to SYSLOG
In-Reply-To: <4FFC911C.4010107@commandprompt.com>
* 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