X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 79AAF52AAA for ; Mon, 16 May 2005 01:40:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07684-07 for ; Mon, 16 May 2005 04:40:50 +0000 (GMT) Received: from web31104.mail.mud.yahoo.com (web31104.mail.mud.yahoo.com [68.142.200.37]) by svr1.postgresql.org (Postfix) with SMTP id D72A2533AC for ; Mon, 16 May 2005 01:40:48 -0300 (ADT) Received: (qmail 21951 invoked by uid 60001); 16 May 2005 04:40:48 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=EOG96wPQAlOWGuKR1gXnwAANygyIsPf1sAaasZAHhyvowvnaDe6Lubw3Cb7DNEvAlQIo+mfmkkz7bBV3e0rb+0gF4rJE+DDDYoFcmmH1GroRnguaBosorJs/AjLKMQcQNdHCXy287LlJfEqiIo+th+9PQxN/lirhOB5SyZxgkdM= ; Message-ID: <20050516044048.21949.qmail@web31104.mail.mud.yahoo.com> Received: from [69.201.130.192] by web31104.mail.mud.yahoo.com via HTTP; Sun, 15 May 2005 21:40:48 PDT Date: Sun, 15 May 2005 21:40:48 -0700 (PDT) From: Reply-To: ogjunk-pgjedan@yahoo.com Subject: Re: DB replicators comparison; (vs. DB upgrade via pg_dump) To: pgsql-admin@postgresql.org In-Reply-To: 6667 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.104 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_YAHOO_RCVD, INFO_TLD, NO_REAL_NAME X-Spam-Level: *** X-Archive-Number: 200505/207 X-Sequence-Number: 17636 Hello, Thanks for the explanation :) I thought there was some technical limitation when dump/reload is used, and I just wasn't seeing it after my dump/reload successfully got me from 7.3.4 to 8.0.3. Still, DB replication sounds very useful, so I'd still be interested in Slony-I, Daffodil, and Mammoth comparison, if anyone has used more than one of them. Thanks, Otis --- Christopher Browne wrote: > A long time ago, in a galaxy far, far away, ogjunk-pgjedan@yahoo.com > wrote: > > I am about to upgrade from 7.3.4 to 8.0.3, and I read that using a > DB > > replication tool is a good way to go about it. > > Replication is useful for this purpose if it helps you cut down on > the > time the transition takes. > > If the database is relatively small, and it only takes a few minutes > to load the data in, then it's far simpler to do a dump/reload. > > But if you discover that the dump/reload takes 4 hours, and you're > only permitted 20 minutes of downtime, the complexities of > replication > may get forced on you... > -- > output = ("cbbrowne" "@" "ntlug.org") > http://linuxdatabases.info/info/slony.html > Sheridan:"So how did you find out all of this?" > Bester:"I'm a telepath. Work it out." <*> > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >