From: Peter Eisentraut <peter_e@gmx.net>
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: Postgres <pgsql-admin@postgresql.org>
Subject: Re: pg_dump etc. versions
Date: Thu, 04 Sep 2008 16:43:42 +0300
Message-ID: <48BFE60E.6090706@gmx.net> (raw)
In-Reply-To: <20080903095613.311500@gmx.net>
References: <20080903095613.311500@gmx.net>
Jan-Peter Seifert wrote:
> I'm wondering if there's a compatibility list of the tools supplied with PostgreSQL - e.g. psql seems to be very server version specific (only major or also minor versions?).
> For pg_dump I'd say users should use the version of the target server if it's already installed, but is this also the case if the target server version is older? Am I completely wrong? Should I always use the pg_dump from the source server? When migrating from 8.1 to 8.2 I get several errors with commands regarding creating users and a lib that had been integrated into the core when restoring from the source server's pg_dump's dump. When using the target server's pg_dump for the dump I don't. But is then really everything okay? And pgAdmin comes with its own set of the PostgreSQL tools ...
I think the only thing that we really check is that pg_dump of a newer
version can dump databases from an older version server. All the other
tools probably only work (completely) with a server from the same major
release.
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: peter_e@gmx.net, Jan-Peter.Seifert@gmx.de
Subject: Re: pg_dump etc. versions
In-Reply-To: <48BFE60E.6090706@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