Detect data changes in postgresql

Question

Is there any way to detect data changes on postgresql wihtout touching the database structure (creating :procedures ,triggers ...).

We thought about a listener that keep listening to log file and parse it in order to know if there are a data change (insert / delete / modification).

I am not sure if the log parsing is efficient enough for such a deal.

For what kind of deal? What are you trying to do? Why can't you change the db? Why must you know when the data changes? Can't you use a different mechanism (such as having the party that changes the database notify you that it has done something)? — Kayaman
– Kayaman, Commented Mar 27, 2017 at 10:17
Logical replication maybe? jdbc.postgresql.org/documentation/head/replication.html — user330315
– user330315, Commented Mar 27, 2017 at 10:21
@Kayaman I have two components(A,B), A uses the real db but B uses a partial cache of the db. This is the reason behind the data change management ,making the cache synchronized with the original db each time there are a data change. — larnouch
– larnouch, Commented Mar 27, 2017 at 10:36

Jean Fiedler · Accepted Answer · 2017-03-27 10:36:33Z

1

You should tell your target and why you can not change the structure for a better help.

But maybe that could help https://dzone.com/articles/audit-log-database-changes-in-postgresql

answered Mar 27, 2017 at 10:36

Jean Fiedler

1711 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Detect data changes in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related