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: Tue, 21 Jun 2011 09:10:50 +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: <201106210910.51035.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Monday 20 June 2011 18:46:33 =CE=BF/=CE=B7 Kevin G=
rittner =CE=AD=CE=B3=CF=81=CE=B1=CF=88=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.
> =20

Thanx, unfortunately the dump is 310GB, and that rather forces me to go to =
the
"migration" direction.

Currently we run a central master system, (which i try to upgrade) and ~ 65=
 slaves in remote locations
(very few of them have TCP/IP connectivity).

I thought of migrating only the central system and leave the slaves at 8.3 =
but this possibility=20
seems rather weak.

> -Kevin
>=20


=2D-=20
Achilleas Mantzios