Installing FullTextSearchT ool tsearch2

Marcel Boscher

Hello everybody,

i tried to "J.U.S.T" install the FullTextSearchT ool tsearch2 under the
guidiance of :
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
<http://www.sai.msu.su/%7Emegera/postgres/gist/tsearch/V2/>
and i'm almost losing my mind...
<runningagainst wallheadsfirst>
after i installed postgre which works fine i change to the folder
/contrib/tsearch2/
there i guessed to use MAKE as it is not mentioned in the manual
seemed to work...
from then everything i tried to execute as guided on their website i get
loads and pagelong error messages varying in many different error messages
most are current transaction is aborted til end stuff
over to syntax error at or near default at character 1
or could not access file$libdir/tsearch2: no such file or directory

does anybody have a short instruction manual with only the syntax
on how to install the fulltextcrap without 10000 words around telling
lies of how wonderful and easy this god made tool is? ...
Gods are here to see:
http://www.sai.msu.su/~megera/postgr...g-teodor-1.jpg
<http://www.sai.msu.su/%7Emegera/postgres/gist/tsearch/V2/>
Just a simple 10 line instruction on what to do after installing
postgre the fashioned old way and now wanting to add tsearch2

Any help would be appreciated
Thx in advance

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

Nov 23 '05 #1

Subscribe Reply

4602

Tino Wildenhain

Hi,

Am Mi, den 18.08.2004 schrieb Marcel Boscher um 17:42:

Hello everybody,

i tried to "J.U.S.T" install the FullTextSearchT ool tsearch2 under the
guidiance of :
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
<http://www.sai.msu.su/%7Emegera/postgres/gist/tsearch/V2/>
and i'm almost losing my mind...
<runningagainst wallheadsfirst>
after i installed postgre which works fine i change to the folder
/contrib/tsearch2/
there i guessed to use MAKE as it is not mentioned in the manual
seemed to work...
from then everything i tried to execute as guided on their website i get
loads and pagelong error messages varying in many different error messages
most are current transaction is aborted til end stuff
over to syntax error at or near default at character 1
or could not access file$libdir/tsearch2: no such file or directory

does anybody have a short instruction manual with only the syntax
on how to install the fulltextcrap without 10000 words around telling
lies of how wonderful and easy this god made tool is? ...

You are telling you read:

http://www.sai.msu.su/~megera/postgr...-V2-intro.html

which seems pretty detailed.
The short name of the database is postgres btw.

HTH
Tino Wildenhain
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 23 '05 #2

Oleg Bartunov

Marcel,

it's very difficult from you message where do you lost.
pgsql version, OS version, cut'n paste of commands you run and
output would be fine.

To install tsearch2 most people need (as postgresql superuser):

1. install postgresql and headers
2. cd contrib/tsearch2
3. make; make install; make installcheck

Note, tsearch2 is just a plain contrib module and installation is
the same as for other modules.

Oleg
On Wed, 18 Aug 2004, Marcel Boscher wrote:

Hello everybody,

i tried to "J.U.S.T" install the FullTextSearchT ool tsearch2 under the
guidiance of :
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
<http://www.sai.msu.su/%7Emegera/postgres/gist/tsearch/V2/>
and i'm almost losing my mind...
<runningagainst wallheadsfirst>
after i installed postgre which works fine i change to the folder
/contrib/tsearch2/
there i guessed to use MAKE as it is not mentioned in the manual
seemed to work...
from then everything i tried to execute as guided on their website i get
loads and pagelong error messages varying in many different error messages
most are current transaction is aborted til end stuff
over to syntax error at or near default at character 1
or could not access file$libdir/tsearch2: no such file or directory

does anybody have a short instruction manual with only the syntax
on how to install the fulltextcrap without 10000 words around telling
lies of how wonderful and easy this god made tool is? ...
Gods are here to see:
http://www.sai.msu.su/~megera/postgr...g-teodor-1.jpg
<http://www.sai.msu.su/%7Emegera/postgres/gist/tsearch/V2/>
Just a simple 10 line instruction on what to do after installing
postgre the fashioned old way and now wanting to add tsearch2

Any help would be appreciated
Thx in advance

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

Regards,
Oleg
_______________ _______________ _______________ _______________ _
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: ol**@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #3

Jeffrey Melloy

Oleg Bartunov wrote:

Marcel,

it's very difficult from you message where do you lost.
pgsql version, OS version, cut'n paste of commands you run and
output would be fine.

To install tsearch2 most people need (as postgresql superuser):

1. install postgresql and headers
2. cd contrib/tsearch2
3. make; make install; make installcheck

Note, tsearch2 is just a plain contrib module and installation is
the same as for other modules.

Oleg
On Wed, 18 Aug 2004, Marcel Boscher wrote:

Hello everybody,

i tried to "J.U.S.T" install the FullTextSearchT ool tsearch2 under the
guidiance of :
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
<http://www.sai.msu.su/%7Emegera/postgres/gist/tsearch/V2/>
and i'm almost losing my mind...
<runningagain stwallheadsfirs t>
after i installed postgre which works fine i change to the folder
/contrib/tsearch2/
there i guessed to use MAKE as it is not mentioned in the manual
seemed to work...
from then everything i tried to execute as guided on their website i get
loads and pagelong error messages varying in many different error messages
most are current transaction is aborted til end stuff
over to syntax error at or near default at character 1
or could not access file$libdir/tsearch2: no such file or directory

does anybody have a short instruction manual with only the syntax
on how to install the fulltextcrap without 10000 words around telling
lies of how wonderful and easy this god made tool is? ...
Gods are here to see:
http://www.sai.msu.su/~megera/postgr...g-teodor-1.jpg
<http://www.sai.msu.su/%7Emegera/postgres/gist/tsearch/V2/>
Just a simple 10 line instruction on what to do after installing
postgre the fashioned old way and now wanting to add tsearch2

Any help would be appreciated
Thx in advance

The instructions I have for installing it are:

cd /POSTGRES_SOURCE _LOCATION//contrib/tsearch2
make
sudo make install
psql < tsearch2.sql

(http://www.visualdistortion.org/sqllogger/install.html)

Not very tough.

Jeff

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 23 '05 #4

Similar topics

2646

Tsearch2 lexeme position

by: Alexander Rüegg | last post by:

Hi, Is it possible to get all the positions of a lexeme in a result-set of a query? For example, we have the table TEXT TEXT_IDX 'TSearch2 is very cool' ... 'It would be much cooler with lexeme positions'

PostgreSQL Database

2881

tsearch2 and unexpected exists

by: Nigel J. Andrews | last post by:

This will be a little vague, it was last night and I can't now do the test in that db (see below) so can't give the exact wording. I seem to remember a report a little while ago about tsearch v2 causing unexpected backend exit messages with 7.3.4 and now I'm getting similar messages unpredictably and I can't find the thread in the archives either. What I did was install tsearch2 using share/contrib/tsearch2.sql, which placed everything...

PostgreSQL Database

1764

backend crashing despite tsearch2 patch

by: psql-mail | last post by:

I have applied the recent tsearch2 patch and recompiled the tsearch2 module but I am still experiencing the same backend crashes as I previously described. Thanks for any help, Mat GDB output:

PostgreSQL Database

446

tsearch2 installation

by: konf | last post by:

Well, now I tried to compile with tsearch2. I do in src direcotry: ../configure then change into contrib/tsearch2 and do make (as I read in manual) and I got:

PostgreSQL Database

2005

questions about tsearch2 (for czech language)

by: Pavel Stehule | last post by:

Hello I try tsearch2 within czech environment. It is works fine, but I have two questions. 1. I have words "se", "ve" in my czech stop words. But I get this words in result. Why? Have I problem with my configuration? tsearch2=# select * from ts_debug('jmenuji se Pavel Stìhule a bydlím ve Skalici.');

PostgreSQL Database

3694

tsearch2: restoring problem

by: Fischer Ulrich | last post by:

Hi I have a problem with the restoring of a database which uses tsearch2. I made a backup as discribed in 'tsearch-v2-intro' on the tsearch2 page. Now i'm trying to restore it into a testdatabase. The problem is, that the entries of the relations 'pg_ts_cfg', 'pg_ts_cfgmap', 'pg_ts_dict' and 'pg_ts_parser' are not correctly restored. I get errors like: psql:restoretest.out:28223: ERROR: copy: line 1, Cannot insert a duplicate key...

PostgreSQL Database

2562

tsearch2 trigger alternative

by: Chris Gamache | last post by:

Tsearch2 comes with its own tsearch2 trigger function. You pass column names to it, and it puts a vanilla tsvector into the column named in TG_ARGV. Not only can you pass column names to it, but you can pass simple functions to it as well. This is magical to me. :) I'm trying to figure out how to do the same thing using plpgsql, except instead of returning a vanilla tsvector, I want to return a specially weighted tsvector. I've created a...

PostgreSQL Database

1787

×ª·¢: docs on tsearch2

by: Ë§ÃÍ | last post by:

-----ÔÊ¼ÓÊ¼þ----- ·¢¼þÈË: Ë§ÃÍ ·¢ËÍÊ±¼ä: 2004Äê3ÔÂ3ÈÕ 10:41 ÊÕ¼þÈË: 'pgsql-hackers@postgresql.org' Ö÷Ìâ: docs on tsearch2 hi all Are there any other docs about tsearch2 except for the 3 docs in \contrib\tsearch2\docs i want some tech docs on tsearch2 thank all---------------------------(end of broadcast)---------------------------TIP 2: you can get off all lists at once with the unregister command (send "unregister...

PostgreSQL Database

3340

Rules and locking within a transaction?...

by: Net Virtual Mailing Lists | last post by:

Hello, If I have a rule like this: CREATE OR REPLACE RULE sometable_update AS ON UPDATE TO table2 DO UPDATE cache SET updated_dt=NULL WHERE tablename='sometable'; CREATE OR REPLACE RULE sometable_insert AS ON INSERT TO table2 DO UPDATE cache SET updated_dt=NULL WHERE tablename='sometable'; CREATE OR REPLACE RULE sometable_delete AS ON DELETE TO table2 DO UPDATE

PostgreSQL Database

9487

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9297

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9735

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8736

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6556

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5168

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5324

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3395

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2697

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General