Thread: Getting started with replication

Are there any docs that deal with replication and
Postgresql? Intro's, faq's, etc.

Can anybody recommend a Postgresql replication
package? I'm really not familiar with any - seems like
there are several, with possibly Slony rising to the
forefront. Are there any docs that compare the various
options?

Would there be any problems replicating data between
Linux and Windows/Cygwin servers?

Thanks,
CSN




__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

Slony seems to be moving to the head of the pack of
replication solutions.  Still too new to say
definitively.

Slony author Jan Wieck has said repeatedly that
replication is used in practice to meet various needs,
and there is no one replication solution that can be
ideal for all of them.  For that reason, there is
likely to continue to be a variety of replication
solutions for PostgreSQL, with none of them part of
the core release.

Anyone who would write a guide to replication in
general, with critiques of the available PostgreSQL
solutions, would be doing a great service.  But I am
not qualified to do it.

--- CSN <cool_screen_name90001@yahoo.com> wrote:
> Are there any docs that deal with replication and
> Postgresql? Intro's, faq's, etc.
>
> Can anybody recommend a Postgresql replication
> package? I'm really not familiar with any - seems
> like
> there are several, with possibly Slony rising to the
> forefront. Are there any docs that compare the
> various
> options?
>
> Would there be any problems replicating data between
> Linux and Windows/Cygwin servers?
>
> Thanks,
> CSN
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail is new and improved - Check it out!
> http://promotions.yahoo.com/new_mail
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>





__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

--- Richard Huxton <dev@archonet.archonet.com> wrote:
> CSN wrote:
> > Are there any docs that deal with replication and
> > Postgresql? Intro's, faq's, etc.
> >
> > Can anybody recommend a Postgresql replication
> > package? I'm really not familiar with any - seems
> like
> > there are several, with possibly Slony rising to
> the
> > forefront. Are there any docs that compare the
> various
> > options?
>
> As you've discovered, there are different options
> available depending on
> what you need. You don't say how you intend to use
> it.

I think I'd like to do a multi-master set up where if
changes to the schema or data are done on any of the
databases (there will be three) they will be
replicated to the other servers. A "CVS" for
databases, if there's such a thing. If not possible
(looks like Slony doesn't support schema changes
(yet?)), one master and two slaves might work.

CSN




__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail