Problems Upgrading from 8.2 to 9.0

From: Adib <amslist(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problems Upgrading from 8.2 to 9.0
Date: 2010-12-22 06:39:32
Message-ID: AANLkTinL+uS+8kCNyJ9aCKzDOw1QHN++6L-=0TRioPUD@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have a very old postgres 8.2 server which I want to upgrade to 9.0.2
server, the server are on different boxes and the 9.0.2 is fully running. I
think that my 8.2 contains tsreach2 which none of my applications use. The
postgres 8.2 is running on Windows 2003 server and 9.0.2 is running on
Windows 2008 R2 server.

I used pg_dumpall --username=postgres > backup.dump on the 8.2 server using
9.0 binaries for pg_dumpall

on the 9.0 server I tried psql --username=postgres < backup.dump and i got
tons of errors a small sample is below. I have no idea what these errors
mean or to get around them, any advice would be appreciated.

pg_dumpall dumps CREATE DDL for the postgres user but when I connect to psql
to restore it tries to create the postgres user which already exists how can
I tell pg_dumpall to ignore dumping the definition of postgres account it
already exists on the target database. I read through the docs on pg_dumpall
but could not
find a command line to do this.

ERROR: type "tsvector" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsquery" is only a shell
ERROR: type "tsvector" is only a shell
ERROR: operator class "gin_tsvector_ops" does not exist for access method
"gin
ERROR: type "tsquery" is only a shell
ERROR: operator class "gist_tp_tsquery_ops" does not exist for access
method "
ERROR: type "tsvector" is only a shell
ERROR: operator class "gist_tsvector_ops" does not exist for access method
"gi
ERROR: type "tsquery" is only a shell
ERROR: operator class "tsquery_ops" does not exist for access method
"btree"
ERROR: type "tsvector" is only a shell
ERROR: operator class "tsvector_ops" does not exist for access method
"btree"

ERROR: function "dex_init(internal)" does not exist
CONTEXT: COPY pg_ts_dict, line 1, column dict_init: "dex_init(internal)"
ERROR: function "prsd_getlexeme(internal,internal,internal)" does not exist
CONTEXT: COPY pg_ts_parser, line 1, column prs_nexttoken:
"prsd_getlexeme(internal,internal,internal)"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-12-22 06:44:56 Re: Problems Upgrading from 8.2 to 9.0
Previous Message Kevin Grittner 2010-12-21 21:21:54 Re: pg_clog not getting cleared