[Gllug] [VACANCY] SQL Developer

Richard Huxton dev at archonet.com
Thu Jun 7 10:03:19 UTC 2007

Dean Wilson wrote:
> On Thu, Jun 07, 2007 at 10:34:36AM +0100, Richard Huxton wrote:
>> I'm not sure I'd ever choose it over PostgreSQL,
> You should seriously reconsider using PostgreSQL anywhere that requires
> replication.
> Slony is... not very good is a polite term, and mammoth isn't widely
> shouted about so I'd be worried about the lack of users and community.

Slony is fiddly, I'll grant you. Seems to do the job where I've used it 
though. Particularly useful for version changeovers with PG*. Where it 
isn't great is in situations where it gets into difficulties (e.g. 
slaves falling behind due to poor network activity etc) - not that I've 
got any great ideas on how to manage situations where the slave just 
can't catch up (due to bandwidth etc).

Never used Mammoth, but Command-Prompt are well-known in the community.

* For those not in the know, on-disk formats are fixed for a set version 
of PostgreSQL, e.g. 8.2.whatever but not between 8.1 and 8.2. This means 
a dump/restore of the database which isn't always desirable for a large 
in-use DB.

   Richard Huxton
   Archonet Ltd
Gllug mailing list  -  Gllug at gllug.org.uk

More information about the GLLUG mailing list