From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL vs Firebird SQL |
Date: | 2016-02-10 19:19:28 |
Message-ID: | 20160210191928.GB6624@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-02-10 19:41:08 | Re: four template0 databases after vacuum |
Previous Message | Kiriakos Georgiou | 2016-02-10 18:52:39 | pg_multixact issues |