Re: Upgrade from 7.4 -> 8.0.1 - problem with dump/restore - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Upgrade from 7.4 -> 8.0.1 - problem with dump/restore
Date
Msg-id 20050203191511.GA61940@winnie.fuhr.org
Whole thread Raw
In response to Upgrade from 7.4 -> 8.0.1 - problem with dump/restore  (Karl Denninger <karl@denninger.net>)
List pgsql-general
On Thu, Feb 03, 2005 at 01:03:57PM -0600, Karl Denninger wrote:

> Trying to move from 7.4.1 to 8.0.1
>
> All goes well until I try to reload after installation.
>
> Dump was done with the 8.0.1 pg_dumpall program
>
> On restore, I get thousands of errors on the console, and of course the
> data doesn't end up back in the system.

Please show the commands you ran and examples of some of the errors --
without knowing more we have no way of figuring out what's wrong.

> The only two "non-standard" things about my 7.4.1 DBMS is that I do have
> significant amonuts of binary data stored in the dbms itself, and in
> addition I have "tsearch" loaded.

Are you using tsearch, or tsearch2?  README.tsearch says that as
of 7.4, tsearch is deprecated in favor of tsearch2.  Did you install
the 8.0.1 version of whatever module you're using?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Hiding databases
Next
From: Wes
Date:
Subject: Indexed leading substring searches - worked, now doesn't