Re: [GENERAL] Getting started with replication

2004-07-15 Thread Jeff Eckermann 
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 [EMAIL PROTECTED] 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 

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [GENERAL] Getting started with replication

2004-07-15 Thread CSN 
--- Richard Huxton [EMAIL PROTECTED] 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 

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match