Обсуждение: Tsearch2 Upgrade from 8.2 to 8.3.1
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/
Hello! I found the solution: Normal export. Normal upgrade procedure. su - postgres # Upgrade tsearch2 # http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html createdb wikidb psql wikidb < /usr/share/pgsql/contrib/tsearch2.sql psql < pg_dumpall.sql postgres Ciao, Gerhard -- http://www.wiesinger.com/ On Thu, 15 May 2008, Gerhard Wiesinger wrote: > 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/ > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >