Re: postgre2postgre

F. wrote:
> Hello,
> I am trying to migrate from postgresql-8.1.11-1.el5_1.1 (i386) to
> postgresql-8.3.4-1.fc10.x86_64. But I can not.
>
> Database uses ltree and tsearch and the problem seems to be this.
>
> I am using,
> pg_dump in first computer and psql in second computer to execute script.
>
> First error:
> psql:informatica.sql:24: ERROR: no se encuentra la función «gtsvector_in» en el archivo «/usr/lib64/pgsql/tsearch2.so»
>
> Anyone know any way to migrate?

tsearch2 became a built in module, there is doco on the website about
how to handle this:

http://www.postgresql.org/docs/8.3/static/tsearch2.html

--
Postgresql & php tutorials
http://www.designmagick.com/