Re: Postgres and geographically diverse replication

On Wed, 2007-04-18 at 16:43 -0400, Bill Moran wrote:
> In response to "Drew Myers" <drew(dot)myers(at)innerwireless(dot)com>:
> >
> > I've been given a task to build a couple of geographically separate
> > servers, which are capable of replicating data between each other.
> >
> > I've surfed through various google results, and most of what I've found
> > seems to be a bit dated, so I thought I'd pose my question here, perhaps
> > for more detailed and more up-to-date info.
> >
> > Is this normally done in a push/pull scenario within the postgres
> > installations themselves, or is additional software required? What are
> > the various replication capabilities?
> >
> > I apologize for the general nature of my questions, I'm new to postgres
> > and to geographically separate replication. Any tips, books, whitepapers
> > or other resources you might be able to point me to is most appreciated.
>
> Generally speaking, when you're talking geographically separate, Slony
> is your best bet. We're using it to maintain data on opposites sides of
> the US with good success.

Successfully using slony over a wide area is going to depend on how much
data you are replicating, how fast the connection between the two sites
is, and how stable the connection between the two sites is.

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.