Tsearch2 Upgrade from 8.2 to 8.3.1

Поиск
Список
Период
Сортировка
От Gerhard Wiesinger
Тема Tsearch2 Upgrade from 8.2 to 8.3.1
Дата
Msg-id alpine.LFD.1.10.0805151511410.14818@bbs.intern
обсуждение исходный текст
Ответы Re: Tsearch2 Upgrade from 8.2 to 8.3.1 with mediawiki
Список pgsql-general
Hello!

I want to upgrade from 8.2 to 8.3.1 but I've problems:
I did a pg_dumpall but this doesn't work. I found the migration guide with
a trick to load the new contrib/tsearch2 module. But how is this done
exactly?
-------------------------------------------------------------------------
http://www.postgresql.org/docs/8.3/interactive/textsearch-migration.html
The old contrib/tsearch2 functions and other objects must be suppressed
when loading pg_dump output from a pre-8.3 database. While many of them
won't load anyway, a few will and then cause problems. One simple way to
deal with this is to load the new contrib/tsearch2 module before restoring
the dump; then it will block the old objects from being loaded.
-------------------------------------------------------------------------

Some other link I've found:
http://sql-info.de/postgresql/notes/converting-tsearch2-to-8.3.html
http://www.sai.msu.su/~megera/wiki/Tsearch2_83_changes
http://archives.postgresql.org/pgsql-hackers/2007-10/msg00509.php


http://translate.google.com/translate?u=http%3A%2F%2Fwww.nabble.com%2FAtualiza%25C3%25A7%25C3%25A3o-de-Mediawiki-para-8.3-td15722654.html&hl=en&ie=UTF8&sl=es&tl=en
http://www.postgresql.org/docs/8.3/interactive/textsearch-migration.html
http://www.postgresql.org/docs/current/static/tsearch2.html#AEN102824
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
http://people.planetpostgresql.org/greg/index.php?/archives/123-MediaWiki-is-Postgres-8.3-compatible.html

Thank you.

Ciao,
Gerhard

--
http://www.wiesinger.com/


В списке pgsql-general по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Howto return values from a function
Следующее
От: Ottavio Campana
Дата:
Сообщение: problem with serial data type and access