From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: dump from 9.0 to 8.3
Date: Wed, 22 Jun 2011 11:14:14 +0300
User-Agent: KMail/1.9.7
References: <201106201841.36877.achill@matrix.gatewaynet.com>
	<4DFF2509020000250003E99E@gw.wicourts.gov>
In-Reply-To: <4DFF2509020000250003E99E@gw.wicourts.gov>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201106221114.15315.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Monday 20 June 2011 18:46:33 =CE=B3=CF=81=CE=AC=CF=
=88=CE=B1=CF=84=CE=B5:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
> =20
> > 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 ?
> >=20
> > I tried with pg_dump -i from the 8.3 server without good results.
> =20
> 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.

=46or the moment, from the server running 9.0,

ALTER DATABASE dynacom SET bytea_output =3D 'escape';
pg_dump dynacom | sed 's/CREATE OR REPLACE/CREATE/g' | bzip2 | ssh 10.9.200=
=2E254 "bzcat | psql dynacom -f -"

seem to do the trick, till now at least, the restore is not yet complete.

> =20
> -Kevin
>=20


=2D-=20
Achilleas Mantzios