Re: postgre2postgre - Mailing list pgsql-sql

From Chris
Subject Re: postgre2postgre
Date
Msg-id 498A19EE.7020406@gmail.com
Whole thread Raw
In response to postgre2postgre  ("F." <dev001@pas-world.com>)
List pgsql-sql
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/



pgsql-sql by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: postgre2postgre
Next
From: Jamie Tufnell
Date:
Subject: current_date vs 'now'