Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F2B2064FCEC for ; Mon, 8 Sep 2008 07:05:35 -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 87499-06 for ; Mon, 8 Sep 2008 07:05:31 -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 95B6964FCE6 for ; Mon, 8 Sep 2008 07:05:30 -0300 (ADT) Received: (qmail 643 invoked by uid 0); 8 Sep 2008 10:05:27 -0000 Received: from 192.124.237.8 by www008.gmx.net with HTTP; Mon, 08 Sep 2008 12:05:27 +0200 (CEST) Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset="iso-8859-1" Date: Mon, 08 Sep 2008 12:05:27 +0200 From: Jan-Peter.Seifert@gmx.de In-Reply-To: <48BFE60E.6090706@gmx.net> Message-ID: <20080908100527.36590@gmx.net> MIME-Version: 1.0 References: <20080903095613.311500@gmx.net> <48BFE60E.6090706@gmx.net> Subject: Re: pg_dump etc. versions To: Peter Eisentraut X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1/cPeoVMsfcyZFp4tpdPw+l6Ao7JNKqXnqb9xc+Hj BLlUPCXRv1i1CpT02/AiiUXXAyjpa/kUhzhw== Content-Transfer-Encoding: 8bit X-GMX-UID: 3sDyAQNJQEV/FRagZ3Vpui1CNzg2NUJs 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/61 X-Sequence-Number: 30154 Hello Peter, thank you very much for your quick reply again. > Datum: Thu, 04 Sep 2008 16:43:42 +0300 > Von: Peter Eisentraut > An: Jan-Peter Seifert > CC: Postgres > 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 older v1.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 server and one of the possible reasons given by pgAdmin III was an feature that came with v8.3 - can't find the note I took at 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