On Wed, Feb 10, 2016 at 01:14:42PM +0200, Achilleas Mantzios wrote: > >>About checksums in our office master DB that's a fine idea, too bad that pg_upgrade doesn't cope with them > >I am sure you have considered "failing over" the master to an > >in-office slave which has got checksums turned on ? > > Is that possible with standard streaming replication? As far as I am > concerned the (master/hot standby) images have to be identical (no initdb > involved). I guess you mean some sort of external (logical?) replication > mechanism? We are trying to avoid initdb and restore for the obvious > reasons. I had been thinking of a one-time, purpose-driven use of Slony. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general