pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shane Ambler <pgsql@007Marketing.com>
To: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: eddy@axa.it
Cc: pgsql-admin@postgresql.org
Subject: Re: dump from 8.x restore to 7.3.x
Date: Thu, 30 Nov 2006 21:39:34 +1030
Message-ID: <456EBBEE.7090107@007Marketing.com> (raw)
In-Reply-To: <475722.43429.qm@web31810.mail.mud.yahoo.com>
References: <475722.43429.qm@web31810.mail.mud.yahoo.com>

Richard Broersma Jr wrote:

> 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.
> 

I don't see that as being the case - there will be exceptions where you 
have new features in an 8.x database that won't work in a 7.x db but 
otherwise it shouldn't matter, the dumps can be used to import into 
other databases than postgres as long as you use dump with inserts 
instead of copy and use common datatypes.

I would expect that if you dump from 7.x into 8.x and have issues then a 
dump from 8.x into 7.x would work as long as you haven't changed your 
schema to add 8.x only features.

If you have any concerns and want a fall back safety net, then you will 
want to either not add any 8.x features or document the changes so that 
the structure can be changed back to be 7.x compatible.

Of course not making any schema changes until you are happy to stay with 
8.x will help and you could just dump data only to go back.


-- 

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz



view thread (10+ messages)  latest in thread

Message-ID: <456EBBEE.7090107@007Marketing.com>
Permalink:  ../456EBBEE.7090107@007Marketing.com/
Also on:    postgresql.org/message-id/456EBBEE.7090107@007Marketing.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: pgsql@007Marketing.com, rabroersma@yahoo.com, eddy@axa.it
  Subject: Re: dump from 8.x restore to 7.3.x
  In-Reply-To: <456EBBEE.7090107@007Marketing.com>
  References: <475722.43429.qm@web31810.mail.mud.yahoo.com> <456EBBEE.7090107@007Marketing.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