From: Edoardo Ceccarelli <eddy@axa.it>
To: Richard Broersma Jr <rabroersma@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: dump from 8.x restore to 7.3.x
Date: Wed, 29 Nov 2006 20:14:25 +0100
Message-ID: <2c5b22d10611291114x13b9bb43j51127528afb8ff20@mail.gmail.com> (raw)
In-Reply-To: <475722.43429.qm@web31810.mail.mud.yahoo.com>
References: <456D992A.90903@axa.it>
<475722.43429.qm@web31810.mail.mud.yahoo.com>
Thank you for this infos, I wasn't sure about this, now, at least, I know
that this is not possible.
On the other hand, even the most experienced database programmer /
administrator when upgrading a production environment can't be 100% sure
about whether the application,will fail or not.
Of course, testing is the only way to ensure that everything will be as
smooth as possible but a real safety net would be to establish a common dump
file format across different PG versions.
I will keep searching ... and testing of course :)
>
> My understanding is that dumps are not backwards compatible. Any dumps
> created with a Version 8.*
> pg_dump cannot be used for any older versions. If you want "play it safe"
> you should create a new
> server for the postgresql version 8.1 to preform validation tests with
> your front-ends. After you
> are satisfied that everything works well you can replace the version 7
> production server with
> version 8.
>
> If you would like a safety net beyond this you could contact one of the
> PostgreSQL consulting
> companies to walk you through the integration of V.8.1 into your
> projection system.
>
> Regards,
>
> Richard Broersma Jr.
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: eddy@axa.it, rabroersma@yahoo.com
Subject: Re: dump from 8.x restore to 7.3.x
In-Reply-To: <2c5b22d10611291114x13b9bb43j51127528afb8ff20@mail.gmail.com>
References: <456D992A.90903@axa.it> <475722.43429.qm@web31810.mail.mud.yahoo.com> <2c5b22d10611291114x13b9bb43j51127528afb8ff20@mail.gmail.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