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
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
-
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
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
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