Search Postgresql Archives

Re: Postgres and geographically diverse replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 2007-04-18 at 16:43 -0400, Bill Moran wrote:
> In response to "Drew Myers" <drew.myers@xxxxxxxxxxxxxxxxx>:
> > 
> > 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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux