From: Guillaume Lelarge <guillaume@lelarge.info>
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: Jiří Hlinka <jiri.hlinka@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump, pg_restore from 9.2 on 8.4 server
Date: Wed, 03 Jul 2013 22:50:56 +0200
Message-ID: <1372884656.2517.1.camel@localhost.localdomain> (raw)
In-Reply-To: <CAB8KJ=i1kje=peSB+eiuD6qYevfCTNJT0qHQfR4CDxSWjRtLvA@mail.gmail.com>
References: <CADCCO5pfBgR0QonbQRXWbTE0OjRBWqr=D3YOThzyWJ2dJeqSVg@mail.gmail.com>
<CAB8KJ=i1kje=peSB+eiuD6qYevfCTNJT0qHQfR4CDxSWjRtLvA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Wed, 2013-07-03 at 20:53 +0900, Ian Lawrence Barwick wrote:
> 2013/7/3 Jiří Hlinka <jiri.hlinka@gmail.com>:
> > Hi All,
> >
> > I have a 8.4 server and I'd like to use --section parameter of pg_dump and
> > pg_restore, which is available only in 9.2.
> >
> > 1. Is it, in general, safe to use 9.2 tools on 8.4 server? AFAIK the tools
> > are backward compatible, at least in case of plain SQL commands it should be
> > compatible, right?
>
> pg_dump is backwards-compatible all the way to 7.0; see:
> http://www.postgresql.org/docs/9.2/static/app-pgdump.html#PG-DUMP-NOTES
>
Sure, but you may not be able to restore it on a less recent release
(ie, in that case, previous than 9.2). If you use a 9.2 pg_dump, you'll
be garanteed to restore it on 9.2 and upper, not lower (not 8.4 for
instance).
--
Guillaume
http://blog.guillaume.lelarge.infohttp://www.dalibo.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: guillaume@lelarge.info, barwick@gmail.com, jiri.hlinka@gmail.com
Subject: Re: pg_dump, pg_restore from 9.2 on 8.4 server
In-Reply-To: <1372884656.2517.1.camel@localhost.localdomain>
* 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