Re: [GENERAL] 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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] tsearch2: pg8.1 to pg8.2
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: 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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] tsearch2: pg8.1 to pg8.2
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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] tsearch2: pg8.1 to pg8.2
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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly