Re: Upgrade from 7.4 -> 8.0.1 - problem with dump/restore

On Thu, Feb 03, 2005 at 01:03:57PM -0600, Karl Denninger wrote:
> Hi folks;
>
> 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.
>
> 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.
>
> Any ideas?

PS: The binary data is in a "BYTEA" field, not a BLOB. It looks ok in the
dump file.

--
--
Karl Denninger (karl(at)denninger(dot)net) Internet Consultant & Kids Rights Activist
http://www.denninger.net My home on the net - links to everything I do!
http://scubaforum.org Your UNCENSORED place to talk about DIVING!
http://www.spamcuda.net SPAM FREE mailboxes - FREE FOR A LIMITED TIME!
http://genesis3.blogspot.com Musings Of A Sentient Mind