Upgrading 8.2.4 to 8.3 With TSearch2

Started by Howard Colealmost 16 years ago3 messagesgeneral
Jump to latest
#1Howard Cole
howardnews@selestial.com

Hi,

I have a database on version 8.2.4 and intend to upgrade to the latest
8.4.3 version. The 8.2 version has Tsearch2 and I know there are issues
in upgrading tsearch2 and therefore I was wondering which is the best
way to do this upgrade.

I am best upgrading from 8.2.4 to the latest 8.2 build and then dumping
that database to restore in an 8.4.3 database, or just dump the existing
8.2.4 database and restore in 8.4.3?

Thanks.

Howard Cole
www.selestial.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Howard Cole (#1)
Re: Upgrading 8.2.4 to 8.3 With TSearch2

Howard Cole <howardnews@selestial.com> writes:

I have a database on version 8.2.4 and intend to upgrade to the latest
8.4.3 version. The 8.2 version has Tsearch2 and I know there are issues
in upgrading tsearch2 and therefore I was wondering which is the best
way to do this upgrade.

There's some suggestions in the fine manual ...
http://www.postgresql.org/docs/8.4/static/textsearch-migration.html

regards, tom lane

#3Howard Cole
howardnews@selestial.com
In reply to: Tom Lane (#2)
Re: Upgrading 8.2.4 to 8.3 With TSearch2

Tom Lane wrote:

There's some suggestions in the fine manual ...
http://www.postgresql.org/docs/8.4/static/textsearch-migration.html

regards, tom lane

Thats the most polite RTFM response I have ever seen! I read the
suggested part of the manual and the update was seamless.

Many thanks.

Howard Cole
www.selestial.com