pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem - Mailing list pgsql-general

From Henrik Zagerholm
Subject pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem
Date
Msg-id F5C37B28-EDCE-4851-9753-C5A6967512E4@mac.se
Whole thread Raw
List pgsql-general
Hi list,

I've downloaded and compiled the new 8.2 to a new debian box.
I also compile and installed tsearch2 support.

Now I have a db on a 8.1.5 box with tsearch2 support.

How do a dump and restore my database to the new 8.2 box?

I get all kinds of errors when trying to restore the db.
Should I uninstall tsearch2 before dumping or?

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 67; 1255 26918
FUNCTION snb_ru_init(internal) postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  could
not find function "snb_ru_init" in file "/usr/local/pgsql/lib/
tsearch2.so"
     Command was: CREATE FUNCTION snb_ru_init(internal) RETURNS internal
     AS '$libdir/tsearch2', 'snb_ru_init'
     LANGUAGE c;
pg_restore: [archiver (db)] could not execute query: ERROR:  function
public.snb_ru_init(internal) does not exist
     Command was: ALTER FUNCTION public.snb_ru_init(internal) OWNER
TO postgres;
WARNING: errors ignored on restore: 2

Regards,
Henrik

pgsql-general by date:

Previous
From: Henrik Zagerholm
Date:
Subject: Re: SOLVED Uninstall pg_trgm
Next
From: "Shoaib Mir"
Date:
Subject: Re: Cast boolean to text