RE: Re: Logging the feature of SQL-level read/write commits

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: RE: Re: Logging the feature of SQL-level read/write commits
Date: 2019-05-05 22:57:09
Message-ID: 1557097029346-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

good point !
wal2Json seems to correspond to your needs,
this is first designed for Change Data Capture,
taht could generate a (very) big size of logs.

You didn't tell us much about your use case ...
and maybe, if the number of data modifications
is not too big, and the number of tables to track
limited, an history_table fed with (after insert,
after update, before delete)
triggers an other (simpler) solution ?

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-05-05 23:07:52 Re: Fixing order of resowner cleanup in 12, for Windows
Previous Message Thomas Munro 2019-05-05 22:13:06 Re: Fixing order of resowner cleanup in 12, for Windows