--0016e6d464cfe7536f0480417b4b
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 [at] 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
--0016e6d464cfe7536f0480417b4b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div>>>I am keep getting error of mismatch of pg_dump version. how sh=
ould one dealing with different version of pg_dump normally?=A0</div><div><=
br></div><div>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</div>
<div>pg_dump: server version: 8.3.9; pg_dump version: 8.3.0</div><div>pg_du=
mp: aborting because of version mismatch =A0(Use the -i option to proceed a=
nyway.)</div><div>pg_dump: *** aborted because of error</div><div><br></div=
>
<div>Process returned exit code 1.</div><div><br></div><div>>>If I us=
e the '-i' option it still give the following error</div><div><br><=
/div><div><br></div><div><div>[postgres [at] localhost ~]$ pg_dump -h 172.16.1.2=
46 -p 5432 -U postgres -Fc -i postgres > postgres</div>
<div>Password:</div><div>pg_dump.bin: server version: 8.4.0; pg_dump.bin ve=
rsion: 8.3.9</div><div>pg_dump.bin: proceeding despite version mismatch</di=
v><div>pg_dump.bin: SQL command failed</div><div>pg_dump.bin: Error message=
from server: ERROR: =A0column "reltriggers" does not exist</div>
<div>LINE 1: ...oles WHERE oid =3D relowner) as rolname, relchecks, reltrig=
ger...</div><div>=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 ^</div><di=
v>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</div>
<div><br></div></div>
--0016e6d464cfe7536f0480417b4b--
