Re: importing a 7.2 db with contrib/tsearch to 7.3

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: importing a 7.2 db with contrib/tsearch to 7.3
Date: 2002-11-21 11:13:24
Message-ID: Pine.LNX.4.44.0211211310340.22698-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


Thats what i do for intarray:

-Install all contrib packages you want to use (*before* restoring
your DB)
-Restore Your DB
-Look in log for errors
-Correct them.

Normally all you shoud get is a bunch of notices that somethings
are allready defined.

I had the same problem as you with gist indexes in intarray.

==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-11-21 11:28:33 Re: Enterprise readiness - mirroring / incremental backup solutions?
Previous Message Ludwig Lim 2002-11-21 11:01:22 Re: Drop NOT NULL constraint !!!

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2002-11-21 11:38:11 psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars
Previous Message Ludwig Lim 2002-11-21 11:01:22 Re: Drop NOT NULL constraint !!!