Thread: pg_dump etc. versions

pg_dump etc. versions

From
"Jan-Peter Seifert"
Date:
Hello,

I'm wondering if there's a compatibility list of the tools supplied with PostgreSQL - e.g. psql seems to be very server
versionspecific (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
caseif 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
beenintegrated into the core when restoring from the source server's pg_dump's dump. When using the target server's
pg_dumpfor the dump I don't. But is then really everything okay? And pgAdmin comes with its own set of the PostgreSQL
tools... 

http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html

What approach for pg_dump (and other tools) should be recommended?

Thank you very much,

Peter
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser

Re: pg_dump etc. versions

From
Peter Eisentraut
Date:
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
serverversion 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
caseif 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
beenintegrated into the core when restoring from the source server's pg_dump's dump. When using the target server's
pg_dumpfor 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.


Re: pg_dump etc. versions

From
Jan-Peter.Seifert@gmx.de
Date:
Hello Peter,

thank you very much for your quick reply again.

> Datum: Thu, 04 Sep 2008 16:43:42 +0300
> Von: Peter Eisentraut <peter_e@gmx.net>
> An: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
> CC: Postgres <pgsql-admin@postgresql.org>
> Betreff: Re: [ADMIN] pg_dump etc. versions

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

http://www.postgresql.org/docs/8.3/static/release-8-3-3.html

Now I have an idea why I couldn't create and restore a dump with pgAdmin III v1.8.4 with one of our databases. In the
olderv1.6.3 the same dump could be restored. v1.8.4 came with the 8.3.0.842 version of pg_dump? 
I guess the version restriction goes for pgAdmin III as well. If I remember correctly I got an error message on an v8.2
serverand one of the possible reasons given by pgAdmin III was an feature that came with v8.3 - can't find the note I
tookat the moment though. 

Thank you very much,

Peter
--
GMX Kostenlose Spiele: Einfach online spielen und Spaß haben mit Pastry Passion!
http://games.entertainment.gmx.net/de/entertainment/games/free/puzzle/6169196