On Mon, Dec 11, 2017 at 01:48:44PM -0300, marcelo wrote: > The installation I'm planning will manage several databases, but not all of > them will change every day. > In order to planning/scripting the pg_dump usage, I would need to know which > databases had some change activity at the end of some day. > How can it be done? Implement INSERT/UPDATE/DELETE/TRUNCATE triggers on all tables and DDL triggers on CREATE, ALTER, DROP, SECURITY LABEL, COMMENT, GRANT or REVOKE. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
