Re: Oracle and Postgresql

From: "Henry" <henry(at)zen(dot)co(dot)za>
To: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Oracle and Postgresql
Date: 2008-09-01 07:51:14
Message-ID: 821d629e1f6f81a8452d2deec31b31a6.squirrel@zenmail.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-www

On Mon, September 1, 2008 4:09 am, Craig Ringer wrote:
> Right now, PostgreSQL has network-based master-to-slave(s) clustering
> using Slony that permits slaves to operate online read-only as reporting
> servers etc. It also covers failover with the use of an external
> heartbeat/STONITH setup. However, it's not completely transparent to the
> application and it's not seen as "part of postgresql".
>
> There are some other options that I'm largely unfamiliar with out there,
> but right now it seems that Slony is the way to go with Pg.

...and Skytools (as used by Skype, I believe, which is now Open Source),
which is far simpler to use and in my experience far more reliable.

Cheers
Henry

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marco Bizzarri 2008-09-01 07:57:08 Re: warning: libssl.so.4, needed by
Previous Message Henry 2008-09-01 07:42:58 Re: Oracle and Postgresql

Browse pgsql-www by date

  From Date Subject
Next Message Thomas Kellerer 2008-09-01 08:31:25 Re: Oracle and Postgresql
Previous Message Henry 2008-09-01 07:42:58 Re: Oracle and Postgresql