On Apr 23, 12:31 am, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > judexhu...@xxxxxxxxx writes: > > When I try to initiate tsearch2 in 8.2.4, I got the following error. > > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch2.so": > > missing magic block > > Apparently you have a pre-8.2 version installed in /usr/local. > Update. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq Thank you for your help. You're absolutely correct. I cleaned up all the 8.1 and got a lot further. After runing psql dbname < tsearch2.sql, there are many SETs, then ... SET psql:tsearch2.sql:7: tsearch2.sql: Too many open files RESET client_min_messages; RESET --tsvector SELECT '1'::tsvector; psql:tsearch2.sql:12: ERROR: type "tsvector" does not exist LINE 1: SELECT '1'::tsvector; ^ ... Any ides about "Too many open files? It never happen to me in the past and I don't know how many times I have successfully done this in the past. A side note, I noticed, I have to run the SQL script int the sql directory, i.e. I can't do psql dbname < /dirname/tsearch2.sql Regards
