Thread: Upgrade from 7.4 -> 8.0.1 - problem with dump/restore
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? -- -- 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
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/
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