Re: dump from 9.0 to 8.3

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Achilleas Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: dump from 9.0 to 8.3
Date: 2011-06-20 15:46:33
Message-ID: 4DFF2509020000250003E99E@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)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.

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marcelo Leite 2011-06-20 17:34:13 Re: dump from 9.0 to 8.3
Previous Message Achilleas Mantzios 2011-06-20 15:41:36 dump from 9.0 to 8.3