I have a database running under pg 8.1.4 that uses tsearch2. I am
upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
install it in pg 8.2.4. This does not seem to work.

Is there a procedure for this that someone can point me to?

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Rick Schumeyer wrote:
> I have a database running under pg 8.1.4 that uses tsearch2. I am
> upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
> install it in pg 8.2.4. This does not seem to work.
>
> Is there a procedure for this that someone can point me to?

You uninstall tsearch2, dump/restore, install tsearch2, reconfigure db.

Joshua D. Drake


>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Rick Schumeyer wrote:
> I have a database running under pg 8.1.4 that uses tsearch2. I am
> upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
> install it in pg 8.2.4. This does not seem to work.
>
> Is there a procedure for this that someone can point me to?

You might find this useful.

http://people.planetpostgresql.org/x...upgrading.html

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

When you say "reconfigure db" does this mean "recreate all your tsearch
indexes"?

Joshua D. Drake wrote:
> Rick Schumeyer wrote:
>> I have a database running under pg 8.1.4 that uses tsearch2. I am
>> upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
>> install it in pg 8.2.4. This does not seem to work.
>>
>> Is there a procedure for this that someone can point me to?
>
> You uninstall tsearch2, dump/restore, install tsearch2, reconfigure db.
>
> Joshua D. Drake
>


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Rick Schumeyer wrote:
> When you say "reconfigure db" does this mean "recreate all your tsearch
> indexes"?

Well if you install tsearch2 ahead of time, the restore will take care
of that for you. What we typically do is this:

schema dump
rip out tsearch2
rip out all foreign keys, index creation etc...
take data dump

install tsearch2
restore skeleton schema
restore data dump
restore foreign keys, indexes etc...

I meant more along the lines of possibly having to add dictionaries etc...

Joshua D. Drake



> Joshua D. Drake wrote:
>> Rick Schumeyer wrote:
>>> I have a database running under pg 8.1.4 that uses tsearch2. I am
>>> upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
>>> install it in pg 8.2.4. This does not seem to work.
>>>
>>> Is there a procedure for this that someone can point me to?
>>
>> You uninstall tsearch2, dump/restore, install tsearch2, reconfigure db.
>>
>> Joshua D. Drake
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend