Date: Tue, 21 Jun 2011 16:47:22 +1000
From: CaT <cat@zip.com.au>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: dump from 9.0 to 8.3
Message-ID: <20110621064721.GH22320@zip.com.au>
References: <201106201841.36877.achill@matrix.gatewaynet.com>
	<4DFF2509020000250003E99E@gw.wicourts.gov>
	<201106210910.51035.achill@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <201106210910.51035.achill@matrix.gatewaynet.com>
Organisation: Furball Inc.
User-Agent: Mutt/1.5.20 (2009-06-14)

On Tue, Jun 21, 2011 at 09:10:50AM +0300, Achilleas Mantzios wrote:
> Στις Monday 20 June 2011 18:46:33 ο/η Kevin Grittner έγραψε:
> > Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
> >  
> > > is there any quick and dirty (or otherwise easy way) to have a
> > > smooth procedure to load into a 8.3 server data dumped by an 9.0
> > > server ?
> > > 
> > > I tried with pg_dump -i from the 8.3 server without good results.
> >  
> > Your best bet might be to dump using the 9.0 pg_dump and then see
> > where the errors are on the load attempt, and edit the file as
> > needed.
> >  
> 
> Thanx, unfortunately the dump is 310GB, and that rather forces me to go to the
> "migration" direction.

I may get beaten up for this but... slony? :)

Afaik should be doable. Your tables just need primary keys.

-- 
  "A search of his car uncovered pornography, a homemade sex aid, women's 
  stockings and a Jack Russell terrier."
    - http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480