Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BA6F2633750; Tue, 23 Feb 2010 05:55:44 -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 82541-06; Tue, 23 Feb 2010 09:55:29 +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 9C540632DAC; Tue, 23 Feb 2010 05:55:33 -0400 (AST) Received: by fxm23 with SMTP id 23so3509876fxm.3 for ; Tue, 23 Feb 2010 01:55:31 -0800 (PST) MIME-Version: 1.0 Received: by 10.223.15.23 with SMTP id i23mr7363705faa.53.1266918920340; Tue, 23 Feb 2010 01:55:20 -0800 (PST) In-Reply-To: References: Date: Tue, 23 Feb 2010 10:55:20 +0100 Message-ID: <9837222c1002230155t5559c940i354cd944fa5916c7@mail.gmail.com> Subject: Re: [GENERAL] pg_dump: aborting because of version mismatch From: Magnus Hagander To: "Net Tree Inc." Cc: pgsql-admin , pgsql-general 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.342 tagged_above=-10 required=5 tests=AWL=0.257, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/175 X-Sequence-Number: 33778 2010/2/23 Net Tree Inc. : >>>I am keep getting error of mismatch of pg_dump version. how should one d= ealing with different version of pg_dump normally? > C:\Program Files\pgAdmin III\1.8\pg_dump.exe -h 192.168.222.129 -p 5433 -= U postgres -F c -b -v -f "C:\Documents and Settings\steven\Desktop\template= .backup" template_postgis > pg_dump: server version: 8.3.9; pg_dump version: 8.3.0 > pg_dump: aborting because of version mismatch =A0(Use the -i option to pr= oceed anyway.) > pg_dump: *** aborted because of error > Process returned exit code 1. >>>If I use the '-i' option it still give the following error > > [postgres@localhost ~]$ pg_dump -h 172.16.1.246 -p 5432 -U postgres -Fc -= i postgres > postgres > Password: > pg_dump.bin: server version: 8.4.0; pg_dump.bin version: 8.3.9 > pg_dump.bin: proceeding despite version mismatch > pg_dump.bin: SQL command failed > pg_dump.bin: Error message from server: ERROR: =A0column "reltriggers" do= es not exist > LINE 1: ...oles WHERE oid =3D relowner) as rolname, relchecks, reltrigger= ... > =A0=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 ^ > pg_dump.bin: The command was: SELECT c.tableoid, c.oid, relname, relacl, = relkind, relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = =3D relowner) as rolname, relchecks, reltriggers, relhasindex, relhasrules,= relhasoids, d.refobjid as owning_tab, d.refobjsubid as owning_col, (SELECT= spcname FROM pg_tablespace t WHERE t.oid =3D c.reltablespace) AS reltables= pace, array_to_string(c.reloptions, ', ') as reloptions from pg_class c lef= t join pg_depend d on (c.relkind =3D 'S' and d.classid =3D c.tableoid and d= .objid =3D c.oid and d.objsubid =3D 0 and d.refclassid =3D c.tableoid and d= .deptype =3D 'a') where relkind in ('r', 'S', 'v', 'c') order by c.oid You're doing two different things here. In the first one it's pg_dump 8.3.0 against server 8.3.9. This should, I think, work if you use -i. It's not recommended, but it should work. In the second one, it's pg_dump 8.3.9 against server 8.4.0. This is simply not supported. You need to use pg_dump 8.4 for server 8.4. --=20 Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/