On Thu, Dec 27, 2007 at 10:49:10AM -0500, Josh Harrison wrote:
> Hi,
> We are trying to use slony and WAL shipping for warm standby for replication
It's unusual to use both. Any reason you want to?
Anyway. . .
> What are the other large 24x7 productions systems that use slony and the
> other WAL archiving of postgresql successfully?
Slony was originally written by Jan Wieck, and released by Afilias
(disclosure: currently my employer). Afilias wrote it because we needed
better replication, and there were no community-offered systems. We run the
registries for several Internet top-level domains, including .info and .org.
We have fairly stringent uptime guarantees, and reasonably high transaction
volumes. The databases are not immense, however. Nevertheless, all the DNS
changes for .org (for instance) today are dependent on Slony operating
correctly. I wouldn't say the system is perfect, but I think I can safely
say we've been quite happy with its flexibility. User-space tools are a
little, uh, geeky still (with the possible exception of the GUI support --
our system deployment makes that a little hard for us to use).
There is someone who is using Slony to operate some rather large databases;
he can post here if he wants to share his experience with you.
A
