From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: dump from 9.0 to 8.3
Date: Tue, 21 Jun 2011 09:10:50 +0300
Message-ID: <201106210910.51035.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 ο/η Kevin Grittner έγραψε:
> 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.
>
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
seems rather weak.
> -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: <201106210910.51035.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