X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 855EAD1E16A for ; Thu, 18 Mar 2004 18:45:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67314-08 for ; Thu, 18 Mar 2004 14:45:30 -0400 (AST) Received: from dervish.jonathangardner.net (dervish.jonathangardner.net [66.92.192.241]) by svr1.postgresql.org (Postfix) with ESMTP id 1C878D1D549 for ; Thu, 18 Mar 2004 14:45:23 -0400 (AST) Received: from jonagard.desktop.amazon.com (207-171-180-101.amazon.com [207.171.180.101]) (authenticated bits=0) by dervish.jonathangardner.net (8.12.10/8.12.10) with ESMTP id i2IIjWxJ005114 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 18 Mar 2004 10:45:33 -0800 From: Jonathan Gardner To: "Colm De Barra" Subject: Re: Date: Thu, 18 Mar 2004 10:41:18 -0800 User-Agent: KMail/1.6 Cc: References: <001b01c41b97$ccf22750$3100a8c0@colm> In-Reply-To: <001b01c41b97$ccf22750$3100a8c0@colm> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200403181041.18614.jgardner@jonathangardner.net> Received-SPF: pass (dervish.jonathangardner.net: sender at 207.171.180.101 was authenticated) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/240 X-Sequence-Number: 12809 On Monday 05 April 2004 10:27 pm, Colm De Barra wrote: > Hey, > > I don't know if this is possible but maybe someone here > will know. > > I compiled version 7.4.1 of postgres and added a specially > patched version of postgis which allows me to store and retrieve > spatial data. > > I have another postgres installation (version 7.3 I think) on > another machine which has all my map data stored on it, but doesn't > have the special patched version of postgis. > > The data is huge - well over 50 gigs - so theres no way I want to have > to copy all the data onto the new box. Is there any way I can point the > new installation at the tables on the old installation ?? > 50 Gigs is a lot. I would just do a direct pipe from dump to psql. You'll need two servers (or two clusters running on one server) -- the old one and the new one. It'll look like this: $ pg_dumpall (old database options) | psql (new database options) template1 -- Jonathan Gardner jgardner@jonathangardner.net