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