tsearch2 errors after db move

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

tsearch2 errors after db move

Matthew Terenzio

I recently moved a database to a new machine:
  PostgreSQL 7.4.7 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC)
3.4.2 [FreeBSD] 20040728

any queries related to tsearch2 give me this error:

ERROR:  cache lookup failed for function 17188

I am running the same versions of Postgres, Freebsd, etc

I guess my next move might be to run untsearch2.sql on both machines,
do a new dump , and try to rebuild tsearch2 from scratch on on both
machines

Unless someone knows better?


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: tsearch2 errors after db move

Oleg Bartunov
On Sun, 3 Jul 2005, Matthew Terenzio wrote:

>
> I recently moved a database to a new machine:
> PostgreSQL 7.4.7 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 3.4.2
> [FreeBSD] 20040728
>
> any queries related to tsearch2 give me this error:
>
> ERROR:  cache lookup failed for function 17188
>
> I am running the same versions of Postgres, Freebsd, etc
>
> I guess my next move might be to run untsearch2.sql on both machines, do a
> new dump , and try to rebuild tsearch2 from scratch on on both machines
>
> Unless someone knows better?
>

yes, search archives and read about regprocedure_7.4.patch.gz
(http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/)

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>              http://archives.postgresql.org
>

  Regards,
  Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [hidden email], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly