Обсуждение: Problem installing tsearch V2 on a FreeBSD
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
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
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