pg_dump etc. versions

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: Postgres <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump etc. versions
Date: 2008-09-03 09:56:13
Message-ID: 20080903095613.311500@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

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

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jan-Peter Seifert 2008-09-03 10:27:01 server/db encoding (mix) issues
Previous Message Jan-Peter Seifert 2008-09-03 09:14:17 Re: Configure DB