Search Postgresql Archives

Re: can't start tsearch2 in 8.2.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Apr 23, 2:10 am, klep...@xxxxxxxxx (Martijn van Oosterhout) wrote:
> On Mon, Apr 23, 2007 at 12:31:32AM -0400, 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.
>
> Perhaps we should add a HINT message with something to the effect of
> "Perhaps it was compiled for an older version".
>
> Have a nice day,
> --
> Martijn van Oosterhout   <klep...@xxxxxxxxx>  http://svana.org/kleptog/
>
> > From each according to his ability. To each according to his ability to litigate.
>
>
>
>  signature.asc
> 1KDownload

If I posted multiple times, please forgive me. Just did not see it go
through for a while.

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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux