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

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@gmail.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
>

"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@gmail.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.linuxadmin@gmail.com">
> me.linuxadmin@gmail.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