Re: operation logging

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: operation logging
Date: 2003-09-12 15:00:15
Message-ID: 1063378815.843.59.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

On Fri, 2003-09-12 at 07:57, Marcin Gil wrote:
> Does PostgreSQL manage an internal log of db operations?
> For example, a user with uid logs into the database
> and updates several rows.. Does engine log it?

Are you referring to table/field change audit logging, or the log-
ging of statements?

Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA

"Eternal vigilance is the price of liberty: power is ever
stealing from the many to the few. The manna of popular liberty
must be gathered each day, or it is rotten... The hand entrusted
with power becomes, either from human depravity or esprit de
corps, the necessary enemy of the people. Only by continual
oversight can the democrat in office be prevented from hardening
into a despot: only by unintermitted agitation can a people be
kept sufficiently awake to principle not to let liberty be
smothered in material prosperity... Never look, for an age when
the people can be quiet and safe. At such times despotism, like
a shrouding mist, steals over the mirror of Freedom"
Wendell Phillips

In response to


Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2003-09-12 15:34:38 Re: Finding connected users
Previous Message Steve Bond 2003-09-12 14:50:32 Error: The database does not exist on the server