Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id E2676634F1A;
	Tue, 23 Feb 2010 06:57:14 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024)
	with ESMTP id 94592-04; Tue, 23 Feb 2010 10:56:58 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f223.google.com (mail-fx0-f223.google.com
	[209.85.220.223])
	by mail.postgresql.org (Postfix) with ESMTP id C1666633727;
	Tue, 23 Feb 2010 06:57:03 -0400 (AST)
Received: by fxm23 with SMTP id 23so3567867fxm.3
	for <multiple recipients>; Tue, 23 Feb 2010 02:57:01 -0800 (PST)
MIME-Version: 1.0
Received: by 10.223.63.20 with SMTP id z20mr824661fah.98.1266922613375; Tue,
	23 Feb 2010 02:56:53 -0800 (PST)
In-Reply-To: <bd9689741002230234t1a0df72apd94b7625aa526391@mail.gmail.com>
References: <bd9689741002230150s21024416ie133445ffbd2f7a@mail.gmail.com>
	<9837222c1002230155t5559c940i354cd944fa5916c7@mail.gmail.com>
	<bd9689741002230234t1a0df72apd94b7625aa526391@mail.gmail.com>
Date: Tue, 23 Feb 2010 11:56:53 +0100
Message-ID: <9837222c1002230256y4f8cdc10pc8759ed294119704@mail.gmail.com>
Subject: Re: [GENERAL] pg_dump: aborting because of version mismatch
From: Magnus Hagander <magnus@hagander.net>
To: "Net Tree Inc." <nettreeinc@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>,
	pgsql-general <pgsql-general@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.343 tagged_above=-10 required=5 tests=AWL=0.256,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201002/177
X-Sequence-Number: 33780

2010/2/23 Net Tree Inc. <nettreeinc@gmail.com>:
> Thanks..
> This is what I am confused about. I installed a ver. 8.4 postgresql, why =
it's pg_dump is 8.3.9?? For first one, how could this possibly having probl=
em using pg_dump that comes with the server install??

Comes with what server install? It depends on how you install
PostgreSQL, and on what platform you are. But clearly you are using a
pg_dump that comes from a previous version. It could be that you have
both installed, but that the 8.3 version comes first in your PATH
perhaps?

> the first one I backup using pgAdmin III ver. 1.8.4 on a ver 8.3.9 postgr=
eSQL server

pgadmin ships with a copy of pg_dump. 1.8 ships with pg_dump from 8.3,
so -i should work there. pgadmin 1.8 isn't supported with server 8.4
at all anyway, so you need pgadmin 1.10 for that - which ships with
pg_dump from 8.4.

> the second one I backup using command line on a ver 8.4 postgreSQL server
> Is this something that can solved by upgrade or reinstall ver. 8.4 of =A0=
pg_dump?
> Is that its only downward compatible but not upward? which mean I can do =
restore on 8.4 from backup created by ver 8.3 pg_dump, but probably won't w=
ork the other way around? Definitely impossible? then what is '-i' use for.=
....?

No. You can restore on 8.4 only if you used pg_dump 8.4. But you ca
nuse pg_dump 8.4 on 8.3 just fine.

-i really is for minor versions only. And due to the fact that it's
not really useful, it's been removed (well the option is there, but it
doesn't do anything) in 8.4.
--=20
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/