Thread: Install Tsearch2

Install Tsearch2

From
"Alexander B."
Date:
Hi,

I need to install tsearch2, but I couldn't find a procedure (step-by-step).
Could you recomend some site or some steps to install.

I used PG 8 on Suse and Debian, and I installed postgres by source.

Thanks in advance.





_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/

Re: Install Tsearch2

From
Jeff Frost
Date:
I believe I followed these instructions the last time I enabled tsearch2:

http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro

These are my crib notes for the English version, you'll have to update paths
etc:

wget http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-english.tar.gz
cd /usr/local/lib
sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz

psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest

INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values ( 'default_english', 'default', 'en_US');

INSERT INTO pg_ts_dict
        (SELECT 'en_ispell',
            dict_init,
            'DictFile="/usr/local/lib/english.dict",'
            'AffFile="/usr/local/lib/english.aff",'
            'StopFile="/usr/share/pgsql/contrib/english.stop"',
            dict_lexize
     FROM pg_ts_dict
     WHERE dict_name = 'ispell_template');

INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
        VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
        VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
        VALUES ('default_english', 'lword', '{en_ispell,en_stem}');

INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'url', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'host', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'sfloat', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'uri', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'int', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'float', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'email', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'word', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'hword', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'nlword', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'nlpart_hword', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'part_hword', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'nlhword', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'file', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'uint', '{simple}');
INSERT INTO pg_ts_cfgmap
        VALUES ('default_english', 'version', '{simple}');

ALTER TABLE album ADD COLUMN idxFTI tsvector;
UPDATE album SET idxFTI=to_tsvector(name);
CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);

CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
             FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);

SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');


Hopefully that helps...

On Thu, 1 Feb 2007, Alexander B. wrote:

> Hi,
>
> I need to install tsearch2, but I couldn't find a procedure (step-by-step).
> Could you recomend some site or some steps to install.
>
> I used PG 8 on Suse and Debian, and I installed postgres by source.
>
> Thanks in advance.
>
>
>
>
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor op��o para voc�!
> Experimente j� e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate
>
>

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

Re: Install Tsearch2

From
"Shoaib Mir"
Date:
It already is there in the contrib folder within the source. While in the tsearch2 folder you just need to do a 'make' and 'make install' and then then run the tsearch.sql file so that you can register the tsearch2 functions.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/2/07, Alexander B. < burbello3000@yahoo.com.br> wrote:
Hi,

I need to install tsearch2, but I couldn't find a procedure (step-by-step).
Could you recomend some site or some steps to install.

I used PG 8 on Suse and Debian, and I installed postgres by source.

Thanks in advance.





_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Re: Install Tsearch2

From
Jeff Frost
Date:
BTW, this was for an RPM installed version of postgresql.  As Shoab mentions
in another mail, if you have compiled postgresql from tarball, you'll have to
cd into the contrib/tsearch2 dir and make && make install before  you can do
this stuff.

On Thu, 1 Feb 2007, Jeff Frost wrote:

> I believe I followed these instructions the last time I enabled tsearch2:
>
> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
>
> These are my crib notes for the English version, you'll have to update paths
> etc:
>
> wget
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-english.tar.gz
> cd /usr/local/lib
> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
>
> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
>
> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
> 'default_english', 'default', 'en_US');
>
> INSERT INTO pg_ts_dict
>       (SELECT 'en_ispell',
>            dict_init,
>            'DictFile="/usr/local/lib/english.dict",'
>            'AffFile="/usr/local/lib/english.aff",'
>            'StopFile="/usr/share/pgsql/contrib/english.stop"',
>            dict_lexize
>     FROM pg_ts_dict
>     WHERE dict_name = 'ispell_template');
>
> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>       VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>       VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>       VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
>
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'url', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'host', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'sfloat', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'uri', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'int', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'float', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'email', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'word', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'hword', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'nlword', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'nlpart_hword', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'part_hword', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'nlhword', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'file', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'uint', '{simple}');
> INSERT INTO pg_ts_cfgmap
>       VALUES ('default_english', 'version', '{simple}');
>
> ALTER TABLE album ADD COLUMN idxFTI tsvector;
> UPDATE album SET idxFTI=to_tsvector(name);
> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
>
> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
>            FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
>
> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
>
>
> Hopefully that helps...
>
> On Thu, 1 Feb 2007, Alexander B. wrote:
>
>> Hi,
>>
>> I need to install tsearch2, but I couldn't find a procedure (step-by-step).
>> Could you recomend some site or some steps to install.
>>
>> I used PG 8 on Suse and Debian, and I installed postgres by source.
>>
>> Thanks in advance.
>>
>>
>>
>>
>>
>> _______________________________________________________
>> Yahoo! Mail - Sempre a melhor op��o para voc�!
>> Experimente j� e veja as novidades.
>> http://br.yahoo.com/mailbeta/tudonovo/
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 7: You can help support the PostgreSQL project by donating at
>>
>>                http://www.postgresql.org/about/donate
>>
>>
>
>

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

Re: Install Tsearch2

From
"Alexander B."
Date:
I am getting the follow error:

analise3:/postgres/share/contrib/tsearch2 # make
Makefile:31: ../../src/Makefile.global: No such file or directory
Makefile:32: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
analise3:/postgres/share/contrib/tsearch2 #


What do I need to do?
Thanks






Jeff Frost wrote:
> BTW, this was for an RPM installed version of postgresql. As Shoab
> mentions in another mail, if you have compiled postgresql from
> tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
> make install before you can do this stuff.
>
> On Thu, 1 Feb 2007, Jeff Frost wrote:
>
>> I believe I followed these instructions the last time I enabled
>> tsearch2:
>>
>> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
>>
>> These are my crib notes for the English version, you'll have to
>> update paths etc:
>>
>> wget
>> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-english.tar.gz
>>
>> cd /usr/local/lib
>> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
>>
>> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
>>
>> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
>> 'default_english', 'default', 'en_US');
>>
>> INSERT INTO pg_ts_dict
>> (SELECT 'en_ispell',
>> dict_init,
>> 'DictFile="/usr/local/lib/english.dict",'
>> 'AffFile="/usr/local/lib/english.aff",'
>> 'StopFile="/usr/share/pgsql/contrib/english.stop"',
>> dict_lexize
>> FROM pg_ts_dict
>> WHERE dict_name = 'ispell_template');
>>
>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>> VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
>>
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'url', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'host', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'sfloat', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'uri', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'int', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'float', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'email', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'word', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'hword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'nlword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'nlpart_hword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'part_hword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'nlhword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'file', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'uint', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'version', '{simple}');
>>
>> ALTER TABLE album ADD COLUMN idxFTI tsvector;
>> UPDATE album SET idxFTI=to_tsvector(name);
>> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
>>
>> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
>> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
>>
>> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
>>
>>
>> Hopefully that helps...
>>
>> On Thu, 1 Feb 2007, Alexander B. wrote:
>>
>>> Hi,
>>>
>>> I need to install tsearch2, but I couldn't find a procedure
>>> (step-by-step).
>>> Could you recomend some site or some steps to install.
>>>
>>> I used PG 8 on Suse and Debian, and I installed postgres by source.
>>>
>>> Thanks in advance.
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________________
>>> Yahoo! Mail - Sempre a melhor op??o para voc?!
>>> Experimente j? e veja as novidades.
>>> http://br.yahoo.com/mailbeta/tudonovo/
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>
>>> http://www.postgresql.org/about/donate
>>>
>>>
>>
>>
>



_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/



Re: Install Tsearch2

From
Achilleas Mantzios
Date:
Στις Παρασκευή 02 Φεβρουάριος 2007 14:05, ο/η Alexander B. έγραψε:
> I am getting the follow error:
>
> analise3:/postgres/share/contrib/tsearch2 # make
> Makefile:31: ../../src/Makefile.global: No such file or directory
> Makefile:32: /contrib/contrib-global.mk: No such file or directory
> make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
> analise3:/postgres/share/contrib/tsearch2 #

Edit Makefile and correct the
top_builddir = ../..
line to your actual postgresql sources.

>
>
> What do I need to do?
> Thanks
>
> Jeff Frost wrote:
> > BTW, this was for an RPM installed version of postgresql. As Shoab
> > mentions in another mail, if you have compiled postgresql from
> > tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
> > make install before you can do this stuff.
> >
> > On Thu, 1 Feb 2007, Jeff Frost wrote:
> >> I believe I followed these instructions the last time I enabled
> >> tsearch2:
> >>
> >> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
> >>
> >> These are my crib notes for the English version, you'll have to
> >> update paths etc:
> >>
> >> wget
> >> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispe
> >>ll-english.tar.gz
> >>
> >> cd /usr/local/lib
> >> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
> >>
> >> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
> >>
> >> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
> >> 'default_english', 'default', 'en_US');
> >>
> >> INSERT INTO pg_ts_dict
> >> (SELECT 'en_ispell',
> >> dict_init,
> >> 'DictFile="/usr/local/lib/english.dict",'
> >> 'AffFile="/usr/local/lib/english.aff",'
> >> 'StopFile="/usr/share/pgsql/contrib/english.stop"',
> >> dict_lexize
> >> FROM pg_ts_dict
> >> WHERE dict_name = 'ispell_template');
> >>
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
> >>
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'url', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'host', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'sfloat', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uri', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'int', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'float', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'email', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'word', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlpart_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'part_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlhword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'file', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uint', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'version', '{simple}');
> >>
> >> ALTER TABLE album ADD COLUMN idxFTI tsvector;
> >> UPDATE album SET idxFTI=to_tsvector(name);
> >> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
> >>
> >> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
> >> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
> >>
> >> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
> >>
> >>
> >> Hopefully that helps...
> >>
> >> On Thu, 1 Feb 2007, Alexander B. wrote:
> >>> Hi,
> >>>
> >>> I need to install tsearch2, but I couldn't find a procedure
> >>> (step-by-step).
> >>> Could you recomend some site or some steps to install.
> >>>
> >>> I used PG 8 on Suse and Debian, and I installed postgres by source.
> >>>
> >>> Thanks in advance.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________________
> >>> Yahoo! Mail - Sempre a melhor op??o para voc?!
> >>> Experimente j? e veja as novidades.
> >>> http://br.yahoo.com/mailbeta/tudonovo/
> >>>
> >>> ---------------------------(end of
> >>> broadcast)---------------------------
> >>> TIP 7: You can help support the PostgreSQL project by donating at
> >>>
> >>> http://www.postgresql.org/about/donate
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq

--
Achilleas Mantzios

Re: Install Tsearch2

From
"Shoaib Mir"
Date:
yes, you need to just correct the build directory paths...

---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/2/07, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
Στις Παρασκευή 02 Φεβρουάριος 2007 14:05, ο/η Alexander B. έγραψε:
> I am getting the follow error:
>
> analise3:/postgres/share/contrib/tsearch2 # make
> Makefile:31: ../../src/Makefile.global: No such file or directory
> Makefile:32: /contrib/contrib-global.mk: No such file or directory
> make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
> analise3:/postgres/share/contrib/tsearch2 #

Edit Makefile and correct the
top_builddir = ../..
line to your actual postgresql sources.

>
>
> What do I need to do?
> Thanks
>
> Jeff Frost wrote:
> > BTW, this was for an RPM installed version of postgresql. As Shoab
> > mentions in another mail, if you have compiled postgresql from
> > tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
> > make install before you can do this stuff.
> >
> > On Thu, 1 Feb 2007, Jeff Frost wrote:
> >> I believe I followed these instructions the last time I enabled
> >> tsearch2:
> >>
> >> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
> >>
> >> These are my crib notes for the English version, you'll have to
> >> update paths etc:
> >>
> >> wget
> >> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispe
> >>ll-english.tar.gz
> >>
> >> cd /usr/local/lib
> >> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
> >>
> >> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
> >>
> >> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
> >> 'default_english', 'default', 'en_US');
> >>
> >> INSERT INTO pg_ts_dict
> >> (SELECT 'en_ispell',
> >> dict_init,
> >> 'DictFile="/usr/local/lib/english.dict",'
> >> 'AffFile="/usr/local/lib/english.aff",'
> >> 'StopFile="/usr/share/pgsql/contrib/english.stop"',
> >> dict_lexize
> >> FROM pg_ts_dict
> >> WHERE dict_name = 'ispell_template');
> >>
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
> >>
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'url', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'host', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'sfloat', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uri', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'int', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'float', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'email', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'word', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlpart_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'part_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlhword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'file', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uint', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'version', '{simple}');
> >>
> >> ALTER TABLE album ADD COLUMN idxFTI tsvector;
> >> UPDATE album SET idxFTI=to_tsvector(name);
> >> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
> >>
> >> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
> >> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
> >>
> >> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
> >>
> >>
> >> Hopefully that helps...
> >>
> >> On Thu, 1 Feb 2007, Alexander B. wrote:
> >>> Hi,
> >>>
> >>> I need to install tsearch2, but I couldn't find a procedure
> >>> (step-by-step).
> >>> Could you recomend some site or some steps to install.
> >>>
> >>> I used PG 8 on Suse and Debian, and I installed postgres by source.
> >>>
> >>> Thanks in advance.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________________
> >>> Yahoo! Mail - Sempre a melhor op??o para voc?!
> >>> Experimente j? e veja as novidades.
> >>> http://br.yahoo.com/mailbeta/tudonovo/
> >>>
> >>> ---------------------------(end of
> >>> broadcast)---------------------------
> >>> TIP 7: You can help support the PostgreSQL project by donating at
> >>>
> >>> http://www.postgresql.org/about/donate
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq

--
Achilleas Mantzios

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Re: Install Tsearch2

From
Peter Eisentraut
Date:
Am Freitag, 2. Februar 2007 13:05 schrieb Alexander B.:
> I am getting the follow error:
>
> analise3:/postgres/share/contrib/tsearch2 # make
> Makefile:31: ../../src/Makefile.global: No such file or directory
> Makefile:32: /contrib/contrib-global.mk: No such file or directory
> make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
> analise3:/postgres/share/contrib/tsearch2 #

Run configure first.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: ADMIN Install Tsearch2 - new dic

From
"Alexander B."
Date:
Sorry for insist, but how can I add a new language, specially portuguese?
I could execute the file "tsearch2.sql", but I need to configure in my
language.

Thanks in advance.






Jeff Frost escreveu:
> BTW, this was for an RPM installed version of postgresql. As Shoab
> mentions in another mail, if you have compiled postgresql from
> tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
> make install before you can do this stuff.
>
> On Thu, 1 Feb 2007, Jeff Frost wrote:
>
>> I believe I followed these instructions the last time I enabled
>> tsearch2:
>>
>> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
>>
>> These are my crib notes for the English version, you'll have to
>> update paths etc:
>>
>> wget
>> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-english.tar.gz
>>
>> cd /usr/local/lib
>> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
>>
>> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
>>
>> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
>> 'default_english', 'default', 'en_US');
>>
>> INSERT INTO pg_ts_dict
>> (SELECT 'en_ispell',
>> dict_init,
>> 'DictFile="/usr/local/lib/english.dict",'
>> 'AffFile="/usr/local/lib/english.aff",'
>> 'StopFile="/usr/share/pgsql/contrib/english.stop"',
>> dict_lexize
>> FROM pg_ts_dict
>> WHERE dict_name = 'ispell_template');
>>
>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>> VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
>>
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'url', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'host', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'sfloat', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'uri', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'int', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'float', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'email', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'word', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'hword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'nlword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'nlpart_hword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'part_hword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'nlhword', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'file', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'uint', '{simple}');
>> INSERT INTO pg_ts_cfgmap
>> VALUES ('default_english', 'version', '{simple}');
>>
>> ALTER TABLE album ADD COLUMN idxFTI tsvector;
>> UPDATE album SET idxFTI=to_tsvector(name);
>> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
>>
>> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
>> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
>>
>> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
>>
>>
>> Hopefully that helps...
>>
>> On Thu, 1 Feb 2007, Alexander B. wrote:
>>
>>> Hi,
>>>
>>> I need to install tsearch2, but I couldn't find a procedure
>>> (step-by-step).
>>> Could you recomend some site or some steps to install.
>>>
>>> I used PG 8 on Suse and Debian, and I installed postgres by source.
>>>
>>> Thanks in advance.
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________________
>>> Yahoo! Mail - Sempre a melhor op??o para voc?!
>>> Experimente j? e veja as novidades.
>>> http://br.yahoo.com/mailbeta/tudonovo/
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>
>>> http://www.postgresql.org/about/donate
>>>
>>>
>>
>>
>



_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/



Re: ADMIN Install Tsearch2 - new dic

From
Jeff Frost
Date:
below, you'll need to change every mention of english to portuguese and you'll
also need to find an ispell dictionary for portuguese.  Also, this INSERT:

INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
  'default_english', 'default', 'en_US');

would need to match your locale, so replace default_english with
default_portuguese and en_US with your locale (pt_PT?).

On Fri, 2 Feb 2007, Alexander B. wrote:

> Sorry for insist, but how can I add a new language, specially portuguese?
> I could execute the file "tsearch2.sql", but I need to configure in my
> language.
>
> Thanks in advance.
>
>
>
>
>
>
> Jeff Frost escreveu:
>> BTW, this was for an RPM installed version of postgresql. As Shoab
>> mentions in another mail, if you have compiled postgresql from
>> tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
>> make install before you can do this stuff.
>>
>> On Thu, 1 Feb 2007, Jeff Frost wrote:
>>
>>> I believe I followed these instructions the last time I enabled
>>> tsearch2:
>>>
>>> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
>>>
>>> These are my crib notes for the English version, you'll have to
>>> update paths etc:
>>>
>>> wget
>>> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-english.tar.gz
>>>
>>> cd /usr/local/lib
>>> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
>>>
>>> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
>>>
>>> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
>>> 'default_english', 'default', 'en_US');
>>>
>>> INSERT INTO pg_ts_dict
>>> (SELECT 'en_ispell',
>>> dict_init,
>>> 'DictFile="/usr/local/lib/english.dict",'
>>> 'AffFile="/usr/local/lib/english.aff",'
>>> 'StopFile="/usr/share/pgsql/contrib/english.stop"',
>>> dict_lexize
>>> FROM pg_ts_dict
>>> WHERE dict_name = 'ispell_template');
>>>
>>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>>> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
>>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>>> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
>>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
>>> VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
>>>
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'url', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'host', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'sfloat', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'uri', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'int', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'float', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'email', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'word', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'hword', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'nlword', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'nlpart_hword', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'part_hword', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'nlhword', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'file', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'uint', '{simple}');
>>> INSERT INTO pg_ts_cfgmap
>>> VALUES ('default_english', 'version', '{simple}');
>>>
>>> ALTER TABLE album ADD COLUMN idxFTI tsvector;
>>> UPDATE album SET idxFTI=to_tsvector(name);
>>> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
>>>
>>> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
>>> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
>>>
>>> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
>>>
>>>
>>> Hopefully that helps...
>>>
>>> On Thu, 1 Feb 2007, Alexander B. wrote:
>>>
>>>> Hi,
>>>>
>>>> I need to install tsearch2, but I couldn't find a procedure
>>>> (step-by-step).
>>>> Could you recomend some site or some steps to install.
>>>>
>>>> I used PG 8 on Suse and Debian, and I installed postgres by source.
>>>>
>>>> Thanks in advance.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________________
>>>> Yahoo! Mail - Sempre a melhor op??o para voc?!
>>>> Experimente j? e veja as novidades.
>>>> http://br.yahoo.com/mailbeta/tudonovo/
>>>>
>>>> ---------------------------(end of
>>>> broadcast)---------------------------
>>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>>
>>>> http://www.postgresql.org/about/donate
>>>>
>>>>
>>>
>>>
>>
>
>
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

Re: ADMIN Install Tsearch2 - new dic

From
cedric
Date:
Le vendredi 2 février 2007 17:28, Alexander B. a écrit :
> Sorry for insist, but how can I add a new language, specially portuguese?
> I could execute the file "tsearch2.sql", but I need to configure in my
> language.
you should look at the tsearch2 site, there is a lot of info.
in few steps :
  - use ispell dictionnaries (.aff and .dict files and stop word)
  - and/or use stemmer, make your own dictionnary using 'gendict' tool inside
tsearch2 contrib ( if you use 8.2.x you have to patch tsearch2 in order to be
abble to use the new stemmer library)
  - insert/update your pg_ts_cfg ..cfgmap ..dict .. (see tsearch2 site)

>
> Thanks in advance.
>
> Jeff Frost escreveu:
> > BTW, this was for an RPM installed version of postgresql. As Shoab
> > mentions in another mail, if you have compiled postgresql from
> > tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
> > make install before you can do this stuff.
> >
> > On Thu, 1 Feb 2007, Jeff Frost wrote:
> >> I believe I followed these instructions the last time I enabled
> >> tsearch2:
> >>
> >> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro
> >>
> >> These are my crib notes for the English version, you'll have to
> >> update paths etc:
> >>
> >> wget
> >> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispe
> >>ll-english.tar.gz
> >>
> >> cd /usr/local/lib
> >> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz
> >>
> >> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest
> >>
> >> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values (
> >> 'default_english', 'default', 'en_US');
> >>
> >> INSERT INTO pg_ts_dict
> >> (SELECT 'en_ispell',
> >> dict_init,
> >> 'DictFile="/usr/local/lib/english.dict",'
> >> 'AffFile="/usr/local/lib/english.aff",'
> >> 'StopFile="/usr/share/pgsql/contrib/english.stop"',
> >> dict_lexize
> >> FROM pg_ts_dict
> >> WHERE dict_name = 'ispell_template');
> >>
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}');
> >> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
> >> VALUES ('default_english', 'lword', '{en_ispell,en_stem}');
> >>
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'url', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'host', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'sfloat', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uri', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'int', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'float', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'email', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'word', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlpart_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'part_hword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'nlhword', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'file', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'uint', '{simple}');
> >> INSERT INTO pg_ts_cfgmap
> >> VALUES ('default_english', 'version', '{simple}');
> >>
> >> ALTER TABLE album ADD COLUMN idxFTI tsvector;
> >> UPDATE album SET idxFTI=to_tsvector(name);
> >> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
> >>
> >> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
> >> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
> >>
> >> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
> >>
> >>
> >> Hopefully that helps...
> >>
> >> On Thu, 1 Feb 2007, Alexander B. wrote:
> >>> Hi,
> >>>
> >>> I need to install tsearch2, but I couldn't find a procedure
> >>> (step-by-step).
> >>> Could you recomend some site or some steps to install.
> >>>
> >>> I used PG 8 on Suse and Debian, and I installed postgres by source.
> >>>
> >>> Thanks in advance.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________________
> >>> Yahoo! Mail - Sempre a melhor op??o para voc?!
> >>> Experimente j? e veja as novidades.
> >>> http://br.yahoo.com/mailbeta/tudonovo/
> >>>
> >>> ---------------------------(end of
> >>> broadcast)---------------------------
> >>> TIP 7: You can help support the PostgreSQL project by donating at
> >>>
> >>> http://www.postgresql.org/about/donate
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster