Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BE67364FCDE for ; Wed, 3 Sep 2008 06:56:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80254-03 for ; Wed, 3 Sep 2008 06:56:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id B9F7A64FCEA for ; Wed, 3 Sep 2008 06:56:15 -0300 (ADT) Received: (qmail 10299 invoked by uid 0); 3 Sep 2008 09:56:13 -0000 Received: from 192.124.237.8 by www052.gmx.net with HTTP; Wed, 03 Sep 2008 11:56:13 +0200 (CEST) Content-Type: text/plain; charset="us-ascii" Date: Wed, 03 Sep 2008 11:56:13 +0200 From: "Jan-Peter Seifert" Message-ID: <20080903095613.311500@gmx.net> MIME-Version: 1.0 Subject: pg_dump etc. versions To: Postgres X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX19XVBcEAEpX5FycBgdsv+WcWB5fROiiyMXzGW105P VgoRRJkrkDZuUOs4ySpUaxNZ3HI2iYqqJr5Q== Content-Transfer-Encoding: 7bit X-GMX-UID: bivbOMYYZCEEQk/sa2whd/d4IGhpZQZo X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/3 X-Sequence-Number: 30096 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