From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
---|---|
To: | Rick Schumeyer <rschumeyer(at)ieee(dot)org> |
Subject: | Re: tsearch2: pg8.1 to pg8.2 |
Date: | 2006-12-08 11:08:23 |
Message-ID: | 457947A7.4040008@theendofthetunnel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hannes Dorbath | 2006-12-08 11:14:17 | Re: tsearch2: pg8.1 to pg8.2 |
Previous Message | DANTE Alexandra | 2006-12-08 10:59:45 | Questions about postgresql-8.2.0-2PGDG.src.rpm |