Re: Replication options?

--- Liam Lesboch <liamlesboch@hotmail.com> wrote:

> Thes slashdots post today about the beta releases of
> 8.0 caught the
> attention of my boss and I. Many comments about the
> replicator issue and saw
> many posts about Slony-I in particular. Maybe this
> is the only viable option
> in PostgreSQL? There are others that cost money but
> no where did we surface
> a article that spoke of them in any form of critique
> or tutorial (good or
> bad) and thats a concern for my boss. What large
> companies use replicators
> for PostgreSQL?

You are not likely to read too many reviews of
Slony-I, simply because it is a brand new product.
But many people have been using it already, even as
development code, with good results.

That probably won't impress your bosses.  If you need
a track record, then erServer might be what you need.
erServer is a commercially produced product that was
(is still?) used by Afilias, the provider of registry
services for the .info and .org domains.  That's
serious testing; very large databases and lots of
traffic.

Note that Afilias paid for the development of Slony-I;
they have employed PostgreSQL core developer Jan Wieck
to do that (and probably other things as well).

erServer has now been open sourced, so you can get it
for free.  erServer was created by PostgreSQL, Inc.,
which also provides support services for PostgreSQL
(another point your bosses might be interested in).
Check http://www.pgsql.com for more information.

You can get more information about commercial support
for PostgreSQL at
http://techdocs.postgresql.org/companies.php

HTH

>
> Liam
>
>
> >From: "Liam Lesboch" <liamlesboch@hotmail.com>
> >To: pgsql-general@postgresql.org
> >CC: pgman@candle.pha.pa.us
> >Subject: Re: [GENERAL] Replication options?
> >Date: Tue, 10 Aug 2004 20:29:08 +0000
> >
> >Thank you much,
> >
> >When I perform the google search:
> >http://www.google.com/search?q=slony-i+review
> >
> >I do not find reviews and critiques of slony-i. Are
> there many companies
> >using for their enterprise level database systems?
> Without reviews in the
> >magazines, my bosses uncomfort with PostgreSQL will
> not be remedied with
> >just project maintainers word of mouth.
> >
> >Liam
> >
> >
> >
> >>From: Bruce Momjian <pgman@candle.pha.pa.us>
> >>To: Liam Lesboch <liamlesboch@hotmail.com>
> >>CC: pgsql-general@postgresql.org
> >>Subject: Re: [GENERAL] Replication options?
> >>Date: Tue, 10 Aug 2004 13:12:39 -0400 (EDT)
> >>
> >>
> >>Most people are using Sloney for master/slave
> replication.  You can
> >>search for it easily.
> >>
>
>>---------------------------------------------------------------------------
> >>
> >>Liam Lesboch wrote:
> >> > Greetings,
> >> >
> >> > Yesterday theres was a brief discuissions about
> replications software
> >>for
> >> > PostgreSQL. My boss and I saw only two
> replications for PostgreSQL that
> >>was
> >> > spoken of. We found no reviews on the internet
> that spoke of either or
> >> > compared them and we are considering PostgreSQL
> as an options for a
> >>movement
> >> > from our present platform of Microsoft SQL
> Server that has replications
> >>and
> >> > stored procedures. Can peoples direct me
> towards third-party reviews
> >>online
> >> > of the replications so that we can use as
> examples for consideration of
> >> > products and make migration?
> >> >
> >> > Thank you,
> >> >
> >> > Liam
> >> >
> >> >
>
_________________________________________________________________
> >> > Add photos to your e-mail with MSN 8. Get 2
> months FREE*.
> >> >
> http://join.msn.com/?page=features/featuredemail
> >> >
> >> >
> >> > ---------------------------(end of
> >>broadcast)---------------------------
> >> > TIP 6: Have you searched our list archives?
> >> >
> >> >                http://archives.postgresql.org
> >> >
> >>
> >>--
> >>   Bruce Momjian                        |
> http://candle.pha.pa.us
> >>   pgman@candle.pha.pa.us               |  (610)
> 359-1001
> >>   +  If your life is a hard drive,     |  13
> Roberts Road
> >>   +  Christ can be your backup.        |  Newtown
> Square, Pennsylvania
> >>19073
> >
>
>_________________________________________________________________
> >STOP MORE SPAM with the new MSN 8 and get 2 months
> FREE*
> >http://join.msn.com/?page=features/junkmail
> >
> >
> >---------------------------(end of
> broadcast)---------------------------
> >TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
>
_________________________________________________________________
> MSN 8 with e-mail virus protection service: 2 months
> FREE*
> http://join.msn.com/?page=features/virus
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>




__________________________________
Do you Yahoo!?
Yahoo! Mail � Now with 25x more storage than before!
http://promotions.yahoo.com/new_mail