Is there some way to avoid restoring tsearch2 since full text searching is now part of postgres 9.0, the apps that use the database don't do any full text searching.
2010/12/21 Devrim GÜNDÜZ <dev...@gunduz.org> > On Tue, 2010-12-21 at 22:39 -0800, Adib wrote: > > ERROR: type "tsvector" is only a shell > > ERROR: operator class "gin_tsvector_ops" does not exist for access > > method > > "gin > > *IIRC*, you need to load contrib/tsearch2.sql to database *before* > restoring your backup. > > Regards, > -- > Devrim GÜNDÜZ > PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer > PostgreSQL RPM Repository: http://yum.pgrpms.org > Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr > http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz >