Horton

Re: How to know if a database has changed

Adam Tauno Williams <awilliam@whitemice.org>

View thread View on postgr.es
From: Adam Tauno Williams <awilliam@whitemice.org>
To: pgsql-general@lists.postgresql.org
Date: 2017-12-12T12:40:46Z
Lists: pgsql-general 
> 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.

-- 
Meetings Coordinator, Michigan Association of Railroad Passengers
537 Shirley St NE Grand Rapids, MI 49503-1754 Phone: 616.581.8010
E-mail: awilliam@whitemice.org GPG#D95ED383 Web: http://www.marp.org