Thread: pg_dump etc. versions
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
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.
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