From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: dump from 9.0 to 8.3
Date: Wed, 22 Jun 2011 11:14:14 +0300
Message-ID: <201106221114.15315.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <4DFF2509020000250003E99E@gw.wicourts.gov>
References: <201106201841.36877.achill@matrix.gatewaynet.com>
<4DFF2509020000250003E99E@gw.wicourts.gov>
Στις Monday 20 June 2011 18:46:33 γράψατε:
> 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.
For the moment, from the server running 9.0,
ALTER DATABASE dynacom SET bytea_output = 'escape';
pg_dump dynacom | sed 's/CREATE OR REPLACE/CREATE/g' | bzip2 | ssh 10.9.200.254 "bzcat | psql dynacom -f -"
seem to do the trick, till now at least, the restore is not yet complete.
>
> -Kevin
>
--
Achilleas Mantzios
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: dump from 9.0 to 8.3
In-Reply-To: <201106221114.15315.achill@matrix.gatewaynet.com>
* 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