pg_dump PostgreSQL 8.4

From: "serafin g(dot)segador" <rsegador(at)mydestiny(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump PostgreSQL 8.4
Date: 2009-07-09 08:24:17
Message-ID: d66c44fe0907090124v5645f6f6j67abf093891c4463@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi!.

i am trying to migrate my database from 8.3.7 to 8.4 (both versions
running on the same server windows 2003, hp ml350 quad core xeon) using
pg_dump and restore using pgAdmin III R 1.10.0, this i was able to do. but
i cannot seem to make a backup on 8.4. i keep getting the following error
message:

pg_dump: reading user-defined tables
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: column "reltriggers" does not
exist
LINE 1: ...oles WHERE oid = relowner) as rolname, relchecks, reltrigger...
^
pg_dump: 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
pg_dump: *** aborted because of error
Process returned exit code 1.
is there any configuration setting i need to do. any help would be
appreciated.

regards

raffy segador
destiny cable inc
ncr, philipines

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Heikens 2009-07-09 09:03:04 Re: pg_dump PostgreSQL 8.4
Previous Message John R Pierce 2009-07-09 07:43:48 Re: c++ program to connect to postgre database