Skip site navigation (1) Skip section navigation (2)

Re: Tsearch2 Upgrade from 8.2 to 8.3.1 with mediawiki

From: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Tsearch2 Upgrade from 8.2 to 8.3.1 with mediawiki
Date: 2008-05-30 17:16:39
Message-ID: alpine.LFD.1.10.0805301915070.14498@bbs.intern (view raw or flat)
Thread:
Lists: pgsql-general
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

pgsql-general by date

Next:From: ChristopheDate: 2008-05-30 17:57:43
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade
Previous:From: Merlin MoncureDate: 2008-05-30 16:59:19
Subject: Re: Query planning configuration and solid state drives

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group