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

Shane Ambler wrote:
> 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.

Restoring dumps from new versions into old versions doesn't work 
(without a lot of manual work).  Example cases:

8.2 dump won't install into 8.1 because it sets 
standard_conforming_stings, which can't be set in 8.1

8.1 dump won't install into 8.0 because it dumps users as roles, but 
roles don't exist in 8.0.

8.0 dump won't install into 7.4 because it dumps tablespaces, which 
don't exist in 7.4.

etc. etc.

Obviously you can see that getting pretty bad if you want to go from 8.1 
all the way to 7.3.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



view thread (10+ messages)  latest in thread

Message-ID: <200611301452.37666.peter_e@gmx.net>
Permalink:  ../200611301452.37666.peter_e@gmx.net/
Also on:    postgresql.org/message-id/200611301452.37666.peter_e@gmx.net

 · 

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: peter_e@gmx.net, pgsql@007marketing.com, rabroersma@yahoo.com, eddy@axa.it
  Subject: Re: dump from 8.x restore to 7.3.x
  In-Reply-To: <200611301452.37666.peter_e@gmx.net>
  References: <475722.43429.qm@web31810.mail.mud.yahoo.com> <456EBBEE.7090107@007Marketing.com> <200611301452.37666.peter_e@gmx.net>

* 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