X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 7B1C511F66F2 for ; Mon, 17 Apr 2006 12:22:24 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -4.399 X-Spam-Level: X-Spam-Status: No, score=-4.399 required=5 tests=[ALL_TRUSTED=-1.8, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id jlNGKuo5-OzN for ; Mon, 17 Apr 2006 12:22:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id DD4FF11F66C7 for ; Mon, 17 Apr 2006 12:22:15 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k3HFMEUd031210 for ; Mon, 17 Apr 2006 12:22:15 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k3HErTAr028110 for pgsql-admin@postgresql.org; Mon, 17 Apr 2006 11:53:29 -0300 (ADT) (envelope-from news) From: "Danish" X-Newsgroups: pgsql.admin Subject: Re: tsearch2 installation problem Date: 17 Apr 2006 07:53:39 -0700 Organization: http://groups.google.com Lines: 77 Message-ID: <1145285619.489960.192950@i39g2000cwa.googlegroups.com> References: <1145261769.398138.200480@t31g2000cwb.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com In-Reply-To: User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041215 Firefox/1.0 Red Hat/1.0-12.EL4,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: i39g2000cwa.googlegroups.com; posting-host=61.17.11.47; posting-account=CmeZcg0AAAAGWU4AHS1VPzbfjUvUZ_x6 To: pgsql-admin@postgresql.org X-Archive-Number: 200604/146 X-Sequence-Number: 21315 "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 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:

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-- 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