Search Postgresql Archives

pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux