Re: tsearch2 installation problem

"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(dot)linuxadmin(at)gmail(dot)com> 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> &lt;<a href="mailto:me(dot)linuxadmin(at)gmail(dot)com">
> me(dot)linuxadmin(at)gmail(dot)com</a>&gt; 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:&nbsp;&nbsp;CREATE TABLE / PRIMARY KEY will create<br>implicit index &quot;pg_ts_dict_pkey&quot; for table &quot;pg_ts_dict&quot;<br>CREATE TABLE<br>
> psql:tsearch2.sql:20: ERROR:&nbsp;&nbsp;could not access file &quot;$libdir/tsearch2&quot;:<br>No suchfile or directory<br>psql:tsearch2.sql:26: ERROR:&nbsp;&nbsp;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