"Shoaib Mir" wrote: > I just tried it going to contrib/tsearch2 folder and then did the following: > > make > make install > > It created a tsearch2.so file in the lib directory of pgsql which is used > while registering the tsearch2 functions. Make sure you have that .so file > created under the lib folder of pgsql. > > Hope this helps... > > /Shoaib > > > and then it create > > On 17 Apr 2006 01:16:09 -0700, Danish <me.linuxadmin@xxxxxxxxx> wrote: > > > > Hi Everyone, > > I have installed postgresql 8.1.3.tar.gz. After compiling and > > installing the postgresql is running fine but Im not able to install > > tsearch2. I went under the postgresql source directory > > /usr/local/postgresql8.1.3/contrib and then did a > > #gmake all > > #gmake install > > > > After issuing these commands, a contrib directory was created under > > /usr/local/pgsql/share > > > > Going under the /usr/local/pgsql/share/contrib directory i ran the > > command as user postgres > > > > $psql -d dbname -f tsearch2.sql > > SET > > BEGIN > > psql:tsearch2.sql:13: NOTICE: CREATE TABLE / PRIMARY KEY will create > > implicit index "pg_ts_dict_pkey" for table "pg_ts_dict" > > CREATE TABLE > > psql:tsearch2.sql:20: ERROR: could not access file "$libdir/tsearch2": > > No suchfile or directory > > psql:tsearch2.sql:26: ERROR: current transaction is aborted, commands > > ignored until end of transaction block > > > > then i got the above errors.. > > Can anyone please help me out as to what is going wrong > > Thanks > > Danish > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: Don't 'kill -9' the postmaster > > > > ------=_Part_16490_19174761.1145275606419 > Content-Type: text/html; charset=ISO-8859-1 > Content-Transfer-Encoding: quoted-printable > X-Google-AttachSize: 2007 > > I just tried it going to contrib/tsearch2 folder and then did the following:<br><br>make<br>make install<br><br>It created a tsearch2.so file in the lib directory of pgsql which is used while registering the tsearch2 functions. Make sure you have that .so file created under the lib folder of pgsql. > <br><br>Hope this helps...<br><br>/Shoaib<br><br><br>and then it create<br><br><div><span class="gmail_quote">On 17 Apr 2006 01:16:09 -0700, <b class="gmail_sendername">Danish</b> <<a href="mailto:me.linuxadmin@xxxxxxxxx";> > me.linuxadmin@xxxxxxxxx</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Everyone,<br>I have installed postgresql 8.1.3.tar.gz > . After compiling and<br>installing the postgresql is running fine but Im not able to install<br>tsearch2. I went under the postgresql source directory<br>/usr/local/postgresql8.1.3/contrib and then did a<br>#gmake all<br> > #gmake install<br><br>After issuing these commands, a contrib directory was created under<br>/usr/local/pgsql/share<br><br>Going under the /usr/local/pgsql/share/contrib directory i ran the<br>command as user postgres<br> > <br>$psql -d dbname -f tsearch2.sql<br>SET<br>BEGIN<br>psql:tsearch2.sql:13: NOTICE: CREATE TABLE / PRIMARY KEY will create<br>implicit index "pg_ts_dict_pkey" for table "pg_ts_dict"<br>CREATE TABLE<br> > psql:tsearch2.sql:20: ERROR: could not access file "$libdir/tsearch2":<br>No suchfile or directory<br>psql:tsearch2.sql:26: ERROR: current transaction is aborted, commands<br>ignored until end of transaction block > <br><br>then i got the above errors..<br>Can anyone please help me out as to what is going wrong<br>Thanks<br>Danish<br><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 2: Don't 'kill -9' the postmaster > <br></blockquote></div><br> > > ------=_Part_16490_19174761.1145275606419-- Thanks, I think it worked...tsearch.sql file created a lot of functions and I could see lot of CREATE FUNCTION INSERT statements roll by..... Danish
