| 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: | Whole Thread | Raw Message | 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 |