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 EFAA353B6F for ; Sun, 15 May 2005 03:00:30 -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 35076-04 for ; Sun, 15 May 2005 06:00:22 +0000 (GMT) Received: from web31105.mail.mud.yahoo.com (web31105.mail.mud.yahoo.com [68.142.200.38]) by svr1.postgresql.org (Postfix) with SMTP id 86E9253B43 for ; Sun, 15 May 2005 03:00:20 -0300 (ADT) Received: (qmail 26091 invoked by uid 60001); 15 May 2005 06:00:21 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=JowSWw30H+qY2U+8fraWd2VGtcqV3WezSgzq9yHK74hjuO1AW4KMdMJWckoG/mT9YjDdlokxw1121fwV2Qtl6UX3XW6nMuh0fbQdk9qMiuFas4/L4hrSGfhw07mwtWe5RjXtrfbzTeAwmvPBOp07O/EUw5lZbcxRB03uR1PH94c= ; Message-ID: <20050515060020.26089.qmail@web31105.mail.mud.yahoo.com> Received: from [69.201.130.192] by web31105.mail.mud.yahoo.com via HTTP; Sat, 14 May 2005 23:00:20 PDT Date: Sat, 14 May 2005 23:00:20 -0700 (PDT) From: Reply-To: ogjunk-pgjedan@yahoo.com Subject: DB replicators comparison; (vs. DB upgrade via pg_dump) To: pgsql-admin@postgresql.org 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=2.596 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_YAHOO_RCVD, NO_REAL_NAME X-Spam-Level: ** X-Archive-Number: 200505/205 X-Sequence-Number: 17634 Hello, 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. I see there are multiple replicator choices: Slony-I Daffodil Replicator Mammoth Replicator I was wondering if anyone has tried any 2 or 3 of them, and could share the experiences. My upgrade will be over WAN (old DB and new DB are in different hosting facilities), and it's for a fairly small DB: # du -sh ~postgres/data 4.6G /var/lib/pgsql/data Oh, and couldn't I just pg_dump my old DB, scp the file over to the new DB host, and use psql -f dump-file-here ? Seems simpler than messing with replicators. Thanks, Otis