logging modifying statements only

From: Dmitry Morozovsky <marck(at)rinet(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: logging modifying statements only
Date: 2003-05-20 10:22:29
Message-ID: 20030520141433.Y80651@woozle.rinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello there colleagues,

this question possibly had been asked in past, by I didn't find any definitive
answer.

Is there currently (7.3.2) a way to log only modifying statements (and, surely,
accompanying begin/commit/rollbacks) and skip select's?

Or, should I hack backend/tcop/postgres.c myself? ;-) [yes, I suppose I cound
apparently miss something]

Any ideas?

Sincerely,
D.Marck [DM5020, MCK-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck(at)rinet(dot)ru ***
------------------------------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yusuf 2003-05-20 13:20:15 Increasing Shared Memory size, in order to increase shared buffer size
Previous Message Együd Csaba 2003-05-20 09:14:08 Re: Cygwin - Postgres won't start