X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A9F5B11F671B for ; Mon, 17 Apr 2006 09:06:52 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.325 X-Spam-Level: X-Spam-Status: No, score=0.325 required=5 tests=[AWL=0.324, HTML_MESSAGE=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id ddrNoPbRxGXp for ; Mon, 17 Apr 2006 09:06:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 408BA11F66F3 for ; Mon, 17 Apr 2006 09:06:45 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id z3so471867nzf for ; Mon, 17 Apr 2006 05:06:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=l6tP0jei02wUkMx7rWZDRaq7vF+m1kfuggOSI9PSehr7i9CjT4EwhYj0F2Ubfgymda09t5rrq1q7Vqn47MQ45V7fHiy9CbCWOMSKDuRAQ0RWwCuMQ5ZFu+T4Su8X9EiL3mNx9A1W6elR5U7cjEEJ3sCyr89E5ZYOSaThVm/77QA= Received: by 10.65.100.4 with SMTP id c4mr769952qbm; Mon, 17 Apr 2006 05:06:46 -0700 (PDT) Received: by 10.65.249.3 with HTTP; Mon, 17 Apr 2006 05:06:46 -0700 (PDT) Message-ID: Date: Mon, 17 Apr 2006 17:06:46 +0500 From: "Shoaib Mir" To: pgsql-admin@postgresql.org Subject: Re: tsearch2 installation problem In-Reply-To: <1145261769.398138.200480@t31g2000cwb.googlegroups.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16490_19174761.1145275606419" References: <1145261769.398138.200480@t31g2000cwb.googlegroups.com> X-Archive-Number: 200604/143 X-Sequence-Number: 21312 ------=_Part_16490_19174761.1145275606419 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 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 Content-Disposition: inline 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 l= ib directory of pgsql which is used while registering the tsearch2 function= s. 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 n= ot able to install
tsearch2. I went under the postgresql source director= y
/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 ind= ex "pg_ts_dict_pkey" for table "pg_ts_dict"
CREATE T= ABLE
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 t= o what is going wrong
Thanks
Danish


----------------------= -----(end of broadcast)---------------------------
TIP 2: Don't 'kill -9= ' the postmaster

------=_Part_16490_19174761.1145275606419--