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 CEB7132A205 for ; Wed, 6 Oct 2004 05:06:12 +0100 (BST) 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 56379-02 for ; Wed, 6 Oct 2004 04:06:02 +0000 (GMT) Received: from rambo.iniquinet.com (rambo.iniquinet.com [69.39.89.10]) by svr1.postgresql.org (Postfix) with ESMTP id 479ED32A01D for ; Wed, 6 Oct 2004 05:06:01 +0100 (BST) Received: (qmail 7955 invoked by uid 1010); 6 Oct 2004 00:05:59 -0400 Received: from Robert_Creager@LogicalChaos.org by rambo.iniquinet.com by uid 1002 with qmail-scanner-1.20 (clamscan: 0.70. spamassassin: 2.64. Clear:RC:0(216.150.208.13):SA:0(-4.5/6.0):. Processed in 0.997362 secs); 06 Oct 2004 04:05:59 -0000 Received: from static-13.mm.den.viawest.net (HELO thunder.mshome.net) (perl?test@logicalchaos.org@216.150.208.13) by rambo.iniquinet.com with AES256-SHA encrypted SMTP; 6 Oct 2004 00:05:58 -0400 Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with ESMTP id 94A4DA22; Tue, 5 Oct 2004 22:05:57 -0600 (MDT) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with SMTP id 72C2EA21; Tue, 5 Oct 2004 22:05:55 -0600 (MDT) Date: Tue, 5 Oct 2004 22:05:54 -0600 From: Robert Creager To: Dan Hrabarchuk Cc: "pgsql-admin@postgresql.org" Subject: Re: Duplicating a large database. Message-ID: <20041005220554.7d427efb@thunder.mshome.net> In-Reply-To: <1097022376.3710.55.camel@dan.geotivity.net> References: <1097022376.3710.55.camel@dan.geotivity.net> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed-Claws 0.9.12a (GTK+ 1.2.10; i586-mandrake-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Tue__5_Oct_2004_22_05_54_-0600_NGp5IoIN2GB5m1n+" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=BIZ_TLD X-Spam-Level: X-Archive-Number: 200410/99 X-Sequence-Number: 15092 --Signature=_Tue__5_Oct_2004_22_05_54_-0600_NGp5IoIN2GB5m1n+ Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit When grilled further on (Tue, 05 Oct 2004 17:26:16 -0700), Dan Hrabarchuk confessed: > I need to move a large database to new machine. I'd also like to upgrade > my postgres server from 7.3 to 7.4 (at least). > I think Slony (http://www.slony.org) will do exactly what you desire... Cheers, Rob -- 22:05:07 up 13 days, 31 min, 2 users, load average: 3.26, 3.97, 3.95 Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004 --Signature=_Tue__5_Oct_2004_22_05_54_-0600_NGp5IoIN2GB5m1n+ Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iEUEARECAAYFAkFjbyIACgkQLQ/DKuwDYzmyEACgkFnUGETevzBjOLjOmCB+OHWN vicAmKh2du5KWHG+JtR1tiPuqkRftho= =5yyR -----END PGP SIGNATURE----- --Signature=_Tue__5_Oct_2004_22_05_54_-0600_NGp5IoIN2GB5m1n+--