Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx) 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



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux