pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Danish <me.linuxadmin@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: tsearch2 installation problem
Date: 17 Apr 2006 07:53:39 -0700
Message-ID: <1145285619.489960.192950@i39g2000cwa.googlegroups.com> (raw)
In-Reply-To: <bf54be870604170506t64078ecfgd7e9694d30b71141@mail.gmail.com>
References: <1145261769.398138.200480@t31g2000cwb.googlegroups.com>
	<bf54be870604170506t64078ecfgd7e9694d30b71141@mail.gmail.com>


"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




view thread (3+ messages)

Message-ID: <1145285619.489960.192950@i39g2000cwa.googlegroups.com>
Permalink:  ../1145285619.489960.192950@i39g2000cwa.googlegroups.com/
Also on:    postgresql.org/message-id/1145285619.489960.192950@i39g2000cwa.googlegroups.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: me.linuxadmin@gmail.com
  Subject: Re: tsearch2 installation problem
  In-Reply-To: <1145285619.489960.192950@i39g2000cwa.googlegroups.com>
  References: <1145261769.398138.200480@t31g2000cwb.googlegroups.com> <bf54be870604170506t64078ecfgd7e9694d30b71141@mail.gmail.com> <1145285619.489960.192950@i39g2000cwa.googlegroups.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox