Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem installing tsearch V2 on a FreeBSD

Problem installing tsearch V2 on a FreeBSD

From
Diogo de Oliveira Biazus
Date:
  Hi,

I'm having a problem when I try to run the SQL commands that install the
tsearch2 module,
When I ran the SQL script I've got this message:

SET
BEGIN
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'pg_ts_dict_pkey' for table 'pg_ts_dict'
psql:/usr/ports/databases/postgresql7/work/postgresql-7.3.1/contrib/tsearch2/tsearch.sql:14:
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'pg_ts_dict_pkey' for table 'pg_ts_dict'
CREATE TABLE
CREATE INDEX
ERROR:  Load of file /usr/local/pgsql/lib/tsearch.so failed: dlopen
'/usr/local/pgsql/lib/tsearch.so' failed.
(/usr/local/pgsql/lib/tsearch.so: Undefined symbol "stdout")
psql:/usr/ports/databases/postgresql7/work/postgresql-7.3.1/contrib/tsearch2/tsearch.sql:22:
ERROR:  Load of file /usr/local/pgsql/lib/tsearch.so failed: dlopen
'/usr/local/pgsql/lib/tsearch.so' failed.
(/usr/local/pgsql/lib/tsearch.so: Undefined symbol "stdout") ...

I'm running a PostgreSQL 7.3.1 on a FreeBSD 5.0
Could anybody help me?

Thanks in advance,

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br

Re: Problem installing tsearch V2 on a FreeBSD

From
Teodor Sigaev
Date:
Strange. I use FreeBSD 5.0 with 7.4devel and 7.3.2. No problem.


Did you compile tsearch module in contrib directory of pgsql src tree that was
used for compile your pgsql installation?



Diogo de Oliveira Biazus wrote:
>  Hi,
>
> I'm having a problem when I try to run the SQL commands that install the
> tsearch2 module,
> When I ran the SQL script I've got this message:
>
> SET
> BEGIN
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> 'pg_ts_dict_pkey' for table 'pg_ts_dict'
> psql:/usr/ports/databases/postgresql7/work/postgresql-7.3.1/contrib/tsearch2/tsearch.sql:14:
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> 'pg_ts_dict_pkey' for table 'pg_ts_dict'
> CREATE TABLE
> CREATE INDEX
> ERROR:  Load of file /usr/local/pgsql/lib/tsearch.so failed: dlopen
> '/usr/local/pgsql/lib/tsearch.so' failed.
> (/usr/local/pgsql/lib/tsearch.so: Undefined symbol "stdout")
> psql:/usr/ports/databases/postgresql7/work/postgresql-7.3.1/contrib/tsearch2/tsearch.sql:22:
> ERROR:  Load of file /usr/local/pgsql/lib/tsearch.so failed: dlopen
> '/usr/local/pgsql/lib/tsearch.so' failed.
> (/usr/local/pgsql/lib/tsearch.so: Undefined symbol "stdout") ...
>
> I'm running a PostgreSQL 7.3.1 on a FreeBSD 5.0
> Could anybody help me?
>
> Thanks in advance,
>

--
Teodor Sigaev                                  E-mail: teodor@sigaev.ru

Re: Problem installing tsearch V2 on a FreeBSD

From
Diogo de Oliveira Biazus
Date:
Teodor Sigaev wrote:

> Strange. I use FreeBSD 5.0 with 7.4devel and 7.3.2. No problem.
>
>
> Did you compile tsearch module in contrib directory of pgsql src tree
> that was used for compile your pgsql installation?

Thank you,
I was compiling in the wrong directory.

Thanks again,

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br