From: | Matthew Vernon <matthew(dot)vernon(at)sac(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Replication with infrequent large updates |
Date: | 2012-08-17 15:59:43 |
Message-ID: | m2obm91pyy.fsf@b144-mcv1-mlt.bio.warwick.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a couple of queries about replication. Essentially, I have three
servers reasonably remote from each other. The master server gets large
(order 1-10GB) updates very infrequently (every month or so), which
usually go into new schema. The two slaves need to provide read-only
access to these data, and need to continue operating if the
master is offline. Communication between slaves and master should be
secure. IWBNI users could set their passwords on the slaves, but that's
not essential.
Is this sort of use-case going to work straightforwardly with
postgresql9.1's replication (via log shipping), or will I have to use
slony?
Thanks,
Matthew
--
Matthew Vernon
Quantitative Veterinary Epidemiologist
Epidemiology Research Unit, SAC Inverness
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2012-08-17 16:33:36 | Re: Messy data models (Re: Visualize database schema) |
Previous Message | Albe Laurenz | 2012-08-17 13:16:24 | Re: Best practice non privilege postgres-user |