Re: How to know if a database has changed

From: Walter Nordmann <wnordmann(at)gmx(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to know if a database has changed
Date: 2017-12-11 17:00:18
Message-ID: 0bd24d60-c56b-a0b0-0639-bb30882d46c1@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

a) create triggers on some tables (on update, on delete ...).

let the triggers write some log, check the log or let the triggers
update one central table adding database, tablenames with "table ... in
database ... has been updated, modified'

b) enable detailed loggin and check the system log.

c) both ;)

Regards
walter

Am 11.12.2017 um 17:48 schrieb marcelo:
> 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?
> TIA
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2017-12-11 17:01:01 Re: pg_dump and logging
Previous Message Karsten Hilbert 2017-12-11 16:58:24 Re: How to know if a database has changed