pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.
>

view thread (10+ messages)  latest in thread

Message-ID: <2c5b22d10611291114x13b9bb43j51127528afb8ff20@mail.gmail.com>
Permalink:  ../2c5b22d10611291114x13b9bb43j51127528afb8ff20@mail.gmail.com/
Also on:    postgresql.org/message-id/2c5b22d10611291114x13b9bb43j51127528afb8ff20@mail.gmail.com

 · 

reply

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