Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1EB67632DAC for ; Tue, 23 Feb 2010 05:50:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12309-02 for ; Tue, 23 Feb 2010 09:50:48 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com [74.125.82.46]) by mail.postgresql.org (Postfix) with ESMTP id 5D55E6329C6 for ; Tue, 23 Feb 2010 05:50:48 -0400 (AST) Received: by wwf26 with SMTP id 26so643868wwf.19 for ; Tue, 23 Feb 2010 01:50:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:cc:content-type; bh=7vmzsBgWXne/RSLfxybr2bMd7a450PTMM2lvYu/Odrc=; b=lZ27d0F7YHMUyuiYCmpyQUgklu4jQIdMIToXGH1v8nhUKfzC88YU1kk5IriNC8lE1/ QAaeuwEcKXzTzYI4rwTfe1/2piDAAVXzEKP1FGuntBU5NmZ53lTfrXwin8ASA8KIYGwT HUxEobPdaNfUrUvU1VbysX6Tsr0dZhHP1xxBc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:cc:content-type; b=JQCDarkIYOA9FQzi9YoOyjpcpTwDywNy4KcjNZsQuFLbRZphpEF4T4e06bI/LTRP+t OIgzFnVXNkDuV/DhP+XcMvfrX9yBMc/SxHIvvWxXSVKIQWLO5VspMyi5zDM1aVsUx5KY jeIE/VRUy1KOtUCcUaX9g2o9D5WQwD03mpz+M= MIME-Version: 1.0 Received: by 10.216.88.80 with SMTP id z58mt971797wee.116.1266918646813; Tue, 23 Feb 2010 01:50:46 -0800 (PST) Date: Tue, 23 Feb 2010 17:50:46 +0800 Message-ID: Subject: pg_dump: aborting because of version mismatch From: "Net Tree Inc." Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary=0016e6d464cfe754d30480417b4f X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.183 tagged_above=-10 required=5 tests=BAYES_05=-1.11, HTML_MESSAGE=0.001, MISSING_HEADERS=1.292 X-Spam-Level: X-Archive-Number: 201002/174 X-Sequence-Number: 33777 --0016e6d464cfe754d30480417b4f Content-Type: text/plain; charset=ISO-8859-1 >>I am keep getting error of mismatch of pg_dump version. how should one dealing 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 (Use the -i option to proceed 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: column "reltriggers" does not exist LINE 1: ...oles WHERE oid = relowner) as rolname, relchecks, reltrigger... ^ pg_dump.bin: The command was: SELECT c.tableoid, c.oid, relname, relacl, relkind, relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = 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 = c.reltablespace) AS reltablespace, array_to_string(c.reloptions, ', ') as reloptions from pg_class c left join pg_depend d on (c.relkind = 'S' and d.classid = c.tableoid and d.objid = c.oid and d.objsubid = 0 and d.refclassid = c.tableoid and d.deptype = 'a') where relkind in ('r', 'S', 'v', 'c') order by c.oid --0016e6d464cfe754d30480417b4f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
>>I am keep getting error of mismatch of pg_dump version. how sh= ould one dealing with different version of pg_dump normally?=A0
<= br>
C:\Program Files\pgAdmin III\1.8\pg_dump.exe -h 192.168.222.1= 29 -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_du= mp: aborting because of version mismatch =A0(Use the -i option to proceed a= nyway.)
pg_dump: *** aborted because of error

Process returned exit code 1.

>>If I us= e the '-i' option it still give the following error

<= /div>

[postgres@localhost ~]$ pg_dump -h 172.16.1.2= 46 -p 5432 -U postgres -Fc -i postgres > postgres
Password:
pg_dump.bin: server version: 8.4.0; pg_dump.bin ve= rsion: 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" does not exist
LINE 1: ...oles WHERE oid =3D relowner) as rolname, relchecks, reltrig= ger...
=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_cla= ss c left 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', &#= 39;S', 'v', 'c') order by c.oid

--0016e6d464cfe754d30480417b4f--