Thread: tsearch2 on postgresql 7.3.4
I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system, installed from rpms. There seemed to be some files required for installation of tsearch missing so I downloaded the src bundle too. Tsearch2 then compiled ok but now the command: psql mydb < tsearch2.sql fails with a message along the lines of: unable to stat $libdir/tsearch2 no such file I read up on valena.com about what $libdir was, but there's no mention of how to find out what the value of $libdior is. how do i find out where $libdir is for the current install? what files do i need to move into $libdir directory to get tsearch2 up and running? Thanks! --
Did you make install? psql-mail@freeuk.com wrote: > I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system, > installed from rpms. > > There seemed to be some files required for installation of tsearch > missing so I downloaded the src bundle too. > > Tsearch2 then compiled ok but now the command: > > psql mydb < tsearch2.sql > > fails with a message along the lines of: > unable to stat $libdir/tsearch2 no such file > > I read up on valena.com about what $libdir was, but there's no mention > of how to find out what the value of $libdior is. > > how do i find out where $libdir is for the current install? > > what files do i need to move into $libdir directory to get tsearch2 up > and running? > > Thanks! > -- Teodor Sigaev E-mail: teodor@sigaev.ru
On 06/08/2003 10:43 psql-mail@freeuk.com wrote: > I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system, > installed from rpms. > > There seemed to be some files required for installation of tsearch > missing so I downloaded the src bundle too. > > Tsearch2 then compiled ok but now the command: > > psql mydb < tsearch2.sql > > fails with a message along the lines of: > unable to stat $libdir/tsearch2 no such file > > I read up on valena.com about what $libdir was, but there's no mention > of how to find out what the value of $libdior is. > > how do i find out where $libdir is for the current install? > > what files do i need to move into $libdir directory to get tsearch2 up > and running? > > Thanks! I just tried a make/make install using 7.3.3 sources. I think the problem is that the make file copies the .so to /usr/lib/postgresql which might not be in your lib path. HTH -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
The exact error is: Error: stat failed on file '$libdir/tsearch2': no such file or directory I have done make install. tsearch2.so is located at /usr/local/pgsql/lib/tsearch2.so which is the same directory as fti.so which works. still confused! > > On 06/08/2003 10:43 psql-mail@freeuk.com wrote: > > I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system, > > installed from rpms. > > > > There seemed to be some files required for installation of tsearch > > missing so I downloaded the src bundle too. > > > > Tsearch2 then compiled ok but now the command: > > > > psql mydb < tsearch2.sql > > > > fails with a message along the lines of: > > unable to stat $libdir/tsearch2 no such file > > > > I read up on valena.com about what $libdir was, but there's no mention > > of how to find out what the value of $libdior is. > > > > how do i find out where $libdir is for the current install? > > > > what files do i need to move into $libdir directory to get tsearch2 up > > and running? > > > > Thanks! > > > I just tried a make/make install using 7.3.3 sources. I think the problem > is that the make file copies the .so to /usr/lib/postgresql which might > not be in your lib path. > > HTH > --
Did you compile tsearch2 in contrib directory of pgsql's source tree which was used for install postgresql? Is postgresql istalled at /usr/local/pgsql ? psql-mail@freeuk.com wrote: > The exact error is: > Error: stat failed on file '$libdir/tsearch2': no such file or > directory > > I have done make install. > > tsearch2.so is located at > /usr/local/pgsql/lib/tsearch2.so > > which is the same directory as fti.so which works. > > still confused! > > >>On 06/08/2003 10:43 psql-mail@freeuk.com wrote: >> >>>I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 > > system, > >>>installed from rpms. >>> >>>There seemed to be some files required for installation of tsearch >>>missing so I downloaded the src bundle too. >>> >>>Tsearch2 then compiled ok but now the command: >>> >>>psql mydb < tsearch2.sql >>> >>>fails with a message along the lines of: >>>unable to stat $libdir/tsearch2 no such file >>> >>>I read up on valena.com about what $libdir was, but there's no > > mention > >>>of how to find out what the value of $libdior is. >>> >>>how do i find out where $libdir is for the current install? >>> >>>what files do i need to move into $libdir directory to get tsearch2 > > up > >>>and running? >>> >>>Thanks! >> >> >>I just tried a make/make install using 7.3.3 sources. I think the > > problem > >>is that the make file copies the .so to /usr/lib/postgresql which > > might > >>not be in your lib path. >> >>HTH >> > > -- Teodor Sigaev E-mail: teodor@sigaev.ru
psql-mail@freeuk.com writes:
> tsearch2.so is located at
> /usr/local/pgsql/lib/tsearch2.so
> which is the same directory as fti.so which works.
There may be *an* fti.so there, but it's not necessarily the same one
Postgres is using.
Try "pg_config --pkglibdir" to find out where $libdir really points.
regards, tom lane
Sorted - thank you all. pg_config --pkglibdir /usr/lib/pgsql cp -r PG_SRC_DIR/contrib/tsearch* /usr/lib/pgsql psql mydb < tsearch2.sql Works!