Обсуждение: tsearch2 installation problem
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
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 createda tsearch2.so file in the lib directory of pgsql which is used while registering the tsearch2 functions. Make sureyou 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 Apr2006 01:16:09 -0700, <b class="gmail_sendername">Danish</b> <<a href="mailto:me.linuxadmin@gmail.com"> > me.linuxadmin@gmail.com</a>> 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 underthe 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>Goingunder the /usr/local/pgsql/share/contrib directory i ran the<br>command as userpostgres<br> > <br>$psql -d dbname -f tsearch2.sql<br>SET<br>BEGIN<br>psql:tsearch2.sql:13: NOTICE: CREATE TABLE / PRIMARYKEY will create<br>implicit index "pg_ts_dict_pkey" for table "pg_ts_dict"<br>CREATE TABLE<br> > psql:tsearch2.sql:20: ERROR: could not access file "$libdir/tsearch2":<br>No suchfile or directory<br>psql:tsearch2.sql:26:ERROR: current transaction is aborted, commands<br>ignored until end of transactionblock > <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>---------------------------(endof 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