Replication with infrequent large updates

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

Browse pgsql-general by date

  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