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

From Karl Denninger
Subject Re: Upgrade from 7.4 -> 8.0.1 - problem with dump/restore
Date
Msg-id 20050203132523.A26090@denninger.net
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:
> 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@denninger.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



pgsql-general by date:

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