postgresql fulltext serach ?

[Ergo]

does anyone know if full text searching is enabled in postgress by default ?
im not sure if indexing of this kind has to be enabled by admins...

[Dotable Steve]

Fulltext indexing still isn't part of the core postgresql distribution I don't believe, you have to add an extra module to support fulltext.

We use the redhat/centos rpms, if there is an rpm that supports the fulltext module, then there would be no problem installing that.
I did a search using yum and didn't come up with anything just now, but there may be a package available.

If you let us know what you need, then we'll install it if we can do.

[Ergo]

well i will need full text search :p , im not 100% positive but its called tsearch2 and should come bundled with database ( i have a windows machine and that runs only postgresql 8 so im not sure )

a quote from the postgresql changelog:

New version of full-text indexing
A new full-text indexing suite is available in contrib/tsearch2.

so it should be there ;-)


its one of the greatest advantages over Mysql to have both transactions and fulltext searching ;-). apart from many other things like ANSI compilance

[Dotable Steve]

Yep, I have heard of tsearch2 before. But it wasn't included with postgresql, it was an addon module.

We have RHEL postgresql rpm's installed version 7.4.13-2

So you need to really make sure that everything that you need is within that version.

[Ergo]

where should i search for that ? im not too much into pinguins really...

[Ergo]

http://www.postgresql.org/ftp/binary...hat/rhel-es-3/ - here is Contrib rpm if you could take a look at that. im not sure if im searching for the right thing

im not sure but shouldnt this folder be normally avilable with standard distribution? , ive read somwhere that those modules could be enabled from database user level.... the contrib is bundled with normal distribution on postgresql 8 on windows, the modules are just not enabled by default.

/usr/share/pgsql/contrib - it should be here , the documentation states that they have normally avilable rpms for red hat ;] that what ive found out so far :] w wont help any further because my expertise on linux OS'es is close to none :p

The core of the PostgreSQL object-relational database management system is available in several source and binary formats. The full package includes:
* The core server with full documentation (html, man)
* Several command line tools (e.g. psql, pg_dump, pg_restore)
* C library (libpq) and embedded C processor (ecpg)
* Several server-side procedural languages (e.g. plpgsql, pltcl, plperl)
* Several popular add-on packages (e.g. metaphone, tsearch2, pgcrypto)

as i understand that, this should be already in your distribution but not enabled.... PRETTY POSITIVE ABOUT THAT :}

[Dotable Steve]

For redhat's postgresql project, you can view that here http://sources.redhat.com/rhdb/index.html

I'm searching the redhat contrib package but can't see specifically t2search or any mention of full text support via the project pages.

[Ergo]

the website you mentioned is almost non functional big parts are missing but on postgresql's site inbinary section of download it seems they have the required files for this version,

rhel-es-3 rhel-es-3
rhel-es-3-x86_64 rhel-es-3-x86_64
rhel-es-4 rhel-es-4
rhel-es-4-x86_64 rhel-es-4-x86_64

the red hat's page is very confusing for me ;/ totally unusable.

but it seems to me that this module is probably already bundled or a standard postgres module will work without problem...

What is the difference between PostgreSQL - Red Hat Edition and the PostgreSQL bundled with the Red Hat Linux distribution?
PostgreSQL - Red Hat Edition is a stand-alone package as mentioned above, and is fully tested by Red Hat. The PostgreSQL that ships with Red Hat Linux is simply the current community release of PostgreSQL packaged for installation.

seems to me taht there is nothing more to host in their page as normal addons should work without problems


its the only thing that comes to my mind , thet like on windows these are included somehere ... if not , i cant help any further

[Ergo]

OK ive figured it out. Those "addons" , are plain SQL scripts containing specifications of functions, so it just takes running those queries to enable the feature ;-) so it seems i can create an index of this type by myself. the only thing an admin can do during install is to include those type in default database template ;]

so it seems the problem is solved... i have the necessary sql files from postgresql8 contrib ( but they will work in 7 too ).

i just dont understand why there are make commands there:
http://www.sai.msu.su/~megera/postgr...rman_utf8.html

here a complete guide to installing tsearch2 and it looks like it consists of running quries to database, if im wrong please correct me.

it seems that a correct module SHOULD be already installed in postgresql/lib folder (or something like that), at least in 8 it is bundled.

[Dotable Steve]

Just to follow up on this, tsearch2 is an available library within the contrib package, which is now installed on our servers.