Обсуждение: operation logging
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? Regards -- Marcin Gil marcin.gil @ audax.com.pl, tel. 694972082 OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki tel/fax (44) 7247530, 7244401
Hi Marcin,
Maybe you can change the debug level and redirect postmaster to a
logfile...
On Fri, 2003-09-12 at 14: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?
>
> Regards
Cheers!
Wim De Hul
------------------------------------------------------------------------------
IP SERVICES SPECIALIST
Belgacom Carrier and Wholesale Business Unit (CBU)
------------------------------------------------------------------------------
AS6774
Ripe : WDH25-RIPE
reply-to : NOC{at}belbone{dot}be
peering : peering{at}belbone{dot}be
NOC Tel : +32 2/547.51.00
www.belgacom.be/carrier
------------------------------------------------------------------------------
When a program dies, what you need is a moment of serenity.
------------------------------------------------------------------------------
3:09pm up 3 days, 2:55, 1 user, load average: 1.40, 1.22, 1.08
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.l.johnson@cox.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
> On Fri, 2003-09-12 at 07:57, Marcin Gil wrote: > > Are you referring to table/field change audit logging, or the log- > ging of statements? > The first thing. I'd like to log what operation a user issued (not select, delete/update/insert only) and what rows changed.. Regards, -- Marcin Gil
On Sat, 2003-09-13 at 04:52, marcin.gil@mail.vernet.pl wrote: > > On Fri, 2003-09-12 at 07:57, Marcin Gil wrote: > > > > Are you referring to table/field change audit logging, or the log- > > ging of statements? > > > > The first thing. I'd like to log what operation a user issued (not select, > delete/update/insert only) and what rows changed.. I don't think that PG does that... -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "they love our milk and honey, but preach about another way of living" Merle Haggard, "The Fighting Side Of Me"