pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jonathan Gardner <jgardner@jonathangardner.net>
To: Colm De Barra <colm@aruke.com>
Cc: pgsql-admin@postgresql.org
Subject: Re:
Date: Thu, 18 Mar 2004 10:41:18 -0800
Message-ID: <200403181041.18614.jgardner@jonathangardner.net> (raw)
In-Reply-To: <001b01c41b97$ccf22750$3100a8c0@colm>
References: <001b01c41b97$ccf22750$3100a8c0@colm>

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



view thread (3+ messages)  latest in thread

Message-ID: <200403181041.18614.jgardner@jonathangardner.net>
Permalink:  ../200403181041.18614.jgardner@jonathangardner.net/
Also on:    postgresql.org/message-id/200403181041.18614.jgardner@jonathangardner.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jgardner@jonathangardner.net, colm@aruke.com
  Subject: Re: 
  In-Reply-To: <200403181041.18614.jgardner@jonathangardner.net>
  References: <001b01c41b97$ccf22750$3100a8c0@colm> <200403181041.18614.jgardner@jonathangardner.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox