Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 65338BF6A47
	for <pgsql-admin@postgresql.org>; Wed,  2 May 2012 19:28:31 -0300 (ADT)
Received: from qmta10.westchester.pa.mail.comcast.net ([76.96.62.17])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <rbernier@mediosystems.com>) id 1SPi25-0003MV-Tp
	for pgsql-admin@postgresql.org; Wed, 02 May 2012 22:28:30 +0000
Received: from omta17.westchester.pa.mail.comcast.net ([76.96.62.89])
	by qmta10.westchester.pa.mail.comcast.net with comcast
	id 58rj1j0041vXlb85AAU6PH; Wed, 02 May 2012 22:28:06 +0000
Received: from ubuntu.localnet ([72.5.59.176])
	by omta17.westchester.pa.mail.comcast.net with comcast
	id 5ATq1j00t3o8DtC3dATtyT; Wed, 02 May 2012 22:28:10 +0000
From: Robert Bernier <rbernier@mediosystems.com>
Organization: Medio Systems
To: seapug@postgresql.org
Subject: Re: [seapug] Re: [BUGS] pg_dump: aborting because of server version
	mismatchT
Date: Wed, 2 May 2012 15:27:49 -0700
User-Agent: KMail/1.13.5 (Linux/2.6.35-32-generic; KDE/4.5.5; x86_64; ; )
Cc: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>,
	adelaide-au-pug@postgresql.org, pgsql-admin@postgresql.org,
	pgsql-bugs@postgresql.org, pgsql-sql@postgresql.org,
	"Mitesh Shah" <mitesh.shah@stripes39.com>
References: 
 <CAHofYQQ6yvHGCiHPBqTAL5fU=3haWXdE7oX-3=q=pcGYPajFxg@mail.gmail.com>
	<4FA166A10200002500047721@gw.wicourts.gov>
In-Reply-To: <4FA166A10200002500047721@gw.wicourts.gov>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <201205021527.50466.rbernier@mediosystems.com>
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201205/10
X-Sequence-Number: 39499

There used to be a switch in pg_dump that would disable the version, you can 
even see that's in the man page. However, it is not reccommended and the most 
recent versions have fully deprecated the switch. Technically speaking that 
means that you can even use an older version of pg_dump and it wouldn't 
generate any errors although I wouldn't want to test it out on important stuff.

Robert Bernier



On Wednesday, May 02, 2012 02:53:53 pm Kevin Grittner wrote:
> Mitesh Shah <mitesh.shah@stripes39.com> wrote:
> > *pg_dump: server version: 9.1.2; pg_dump version: 9.0.5*
> > *pg_dump: aborting because of server version mismatch*
> 
> This is not a bug.  Use a version of pg_dump which is at least as
> new as the server.  The older version of pg_dump is unlikely to be
> able to recognize everything in the newer server,
> 
> -Kevin