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 co= uld this possibly having problem using pg_dump that comes with the server i= nstall??=A0

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

the second one I backup using comma= nd line on a ver 8.4 postgreSQL server

Is th= is something that can solved by upgrade or reinstall ver. 8.4 of =A0pg_dump= ?=A0

Is that its only downward compatible but not upward? which m= ean I can do restore on 8.4 from backup created by ver 8.3 pg_dump, but pro= bably won't work the other way around? Definitely impossible? then what= is '-i' use for.....?

Steven

On = Tue, Feb 23, 2010 at 5:55 PM, Magnus Hagander <magnus@hagander.net> wrote:

2010/2/23 Net Tree Inc. <nettreeinc@gmail.com>:

>>>I am keep getting error of mi= smatch 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 543= 3 -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= proceed anyway.)
> pg_dump: *** aborted because of error
> Process returned exit code 1.
>>>If I use the '-i' option it still give the following er= ror
>
> [postgres@localhost ~]$ pg_dump -h 172.16.1.246 -p 5432 -U postgres -F= c -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 "reltrig= gers" 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, relac= l, relkind, relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oi= d =3D relowner) as rolname, relchecks, reltriggers, relhasindex, relhasrule= s, relhasoids, d.refobjid as owning_tab, d.refobjsubid as owning_col, (SELE= CT spcname FROM pg_tablespace t WHERE t.oid =3D c.reltablespace) AS reltabl= espace, array_to_string(c.reloptions, ', ') as reloptions from pg_c= lass 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'= , '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.

--
=A0Magnus Hagander
=A0Me: http://www.ha= gander.net/
=A0Work: http:= //www.redpill-linpro.com/

--
----------------= -----------------------
Steven Huang