Re: How to know if a database has changed - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: How to know if a database has changed
Date
Msg-id 20171212124258.GF15441@hermes.hilbert.loc
Whole thread Raw
In response to Re: How to know if a database has changed  (Adam Tauno Williams <awilliam@whitemice.org>)
List pgsql-general
On Tue, Dec 12, 2017 at 07:40:46AM -0500, Adam Tauno Williams wrote:

> > The next day, that backup will be copied to the cloud.
> 
> What does this mean?  If it is rsync of a local dump to a remote use
> the directory dump format - disable compression - then each table which
> didn't change will 'copy' almost instantly.

I think OP wants to minimize the time spent during shutdown,
not during the next day.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: Adam Tauno Williams
Date:
Subject: Re: How to know if a database has changed
Next
From: Edson Carlos Ericksson Richter
Date:
Subject: Re: How to know if a database has changed