transaction logging

Started by Michael P. Soulieralmost 18 years ago2 messagesgeneral
Jump to latest
#1Michael P. Soulier
michael_soulier@mitel.com

I'm interested in enabling transaction logging, so that I can audit
those logs on a system having issues.

Is there already such a log in postgres 7.4? If not, is there such a
feature and how do I enable it?

I looked in the docs and saw many logging options but nothing for
transactions.

Thanks,
Mike
--
Michael P. Soulier <michael_soulier@mitel.com>, 613-592-2122 x2522
"Any intelligent fool can make things bigger and more complex... It
takes a touch of genius - and a lot of courage to move in the opposite
direction." --Albert Einstein

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Michael P. Soulier (#1)
Re: transaction logging

On Fri, May 16, 2008 at 1:06 PM, Michael P. Soulier
<michael_soulier@mitel.com> wrote:

I'm interested in enabling transaction logging, so that I can audit those
logs on a system having issues.

Is there already such a log in postgres 7.4? If not, is there such a feature
and how do I enable it?

I looked in the docs and saw many logging options but nothing for
transactions.

What, exactly, do you mean by transaction logging? Transaction
failures? DML? 2 phase commits?

After all, everything (well nearly) is a transaction in pgsql, so I'm
not sure exactly what you mean.