Re: dump from 9.0 to 8.3 - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: dump from 9.0 to 8.3
Date
Msg-id 4DFF2509020000250003E99E@gw.wicourts.gov
Whole thread Raw
In response to dump from 9.0 to 8.3  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: dump from 9.0 to 8.3  (Marcelo Leite <leite.marcelo@gmail.com>)
Re: dump from 9.0 to 8.3  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: dump from 9.0 to 8.3  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
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.

-Kevin

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: dump from 9.0 to 8.3
Next
From: Marcelo Leite
Date:
Subject: Re: dump from 9.0 to 8.3