tsearch2: pg8.1 to pg8.2

Rick,

did you load tsearch2 itself into your database ?

Oleg
On Thu, 7 Dec 2006, Rick Schumeyer wrote:

I am trying to copy a database that uses tsearch2 from pg8.1 to pg8.2.

All I did to install tsearch2 was cd to the contrib/tsearch2 directory, then
make, make install.

I then dumped the database from pg8.1 and used psql -f filename db to load in
into pg8.2.

Attempting a query gives an error:

lib2=# select * from item where idxTitle @@ to_tsquery('default', 'money');
ERROR: No dictionary with name 'en_stem'

Is there a document that describes the necessary steps to convert to the
upgraded tsearch2?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

It was my understanding that running pgdump creates a file that contains
all the necessary commands to use tsearch2. That approach has worked for
me to transfer my database from one pg8.1 server to another. I now see
that is does *not* work from pg8.1 to pg8.2.

At your suggestion I loaded tsearch2.sql before loading the pgdump
output. I get some errors in the second part, I believe because it
attempts to load tsearch2 stuff from the pg8.1 database that conflicts
with the pg8.2 stuff from tsearch2.sql. But, the queries seem to work.

So perhaps the answer is, load tsearch2.sql, then load the result of
running pgdump on the 8.1 database, and ignore the errors?

Oleg Bartunov wrote:

TSearch does change from version to version.

- Create your database with template=template0
- Load tsearch2.sql
- Truncate pg_ts_* tables
- Try to restore

Ignore the already exists errors and examine the rest carefully.

On 08.12.2006 00:11, Rick Schumeyer wrote:

It was my understanding that running pgdump creates a file that contains
all the necessary commands to use tsearch2. That approach has worked for
me to transfer my database from one pg8.1 server to another. I now see
that is does *not* work from pg8.1 to pg8.2.

At your suggestion I loaded tsearch2.sql before loading the pgdump
output. I get some errors in the second part, I believe because it
attempts to load tsearch2 stuff from the pg8.1 database that conflicts
with the pg8.2 stuff from tsearch2.sql. But, the queries seem to work.

So perhaps the answer is, load tsearch2.sql, then load the result of
running pgdump on the 8.1 database, and ignore the errors?

--
Regards,
Hannes Dorbath

Sorry, not only load tsearch2.sql. Load your dictionaries as well.

(The SQL-Files generated after Gendict and make in contrib/dict_xx)

On 08.12.2006 12:08, Hannes Dorbath wrote:

TSearch does change from version to version.

- Create your database with template=template0
- Load tsearch2.sql
- Truncate pg_ts_* tables
- Try to restore

Ignore the already exists errors and examine the rest carefully.

--
Regards,
Hannes Dorbath