Thread: postgre2postgre
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? -- -- Publicidad http://www.pas-world.com
On Wed, 2009-02-04 at 22:57 +0100, F. wrote: > 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 was integrated in core as of 8.3. You will need to read this: http://www.postgresql.org/docs/8.3/static/textsearch-migration.html Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org
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/