pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem

From: Henrik Zagerholm <henke(at)mac(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem
Date: 2006-12-07 09:35:06
Message-ID: F5C37B28-EDCE-4851-9753-C5A6967512E4@mac.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-12-07 09:44:30 Re: Cast boolean to text
Previous Message Henrik Zagerholm 2006-12-07 09:34:32 Re: SOLVED Uninstall pg_trgm