Hi all, I have been working on upgrading postgresql 8.2 to 8.3 on our test server but have not been able to successfully migrate the evergreen data after the upgrade using the postgresql standard dump_all routine recommended here: http://www.postgresql.org/docs/8.3/static/install-upgrading.html .
When trying to restore the data a number of errors occur. One of the first is "tsvector is only a shell:" which I believe is related to the tsearch add on. I also get thousands of "Invalid Command" errors in the output when trying to restore. Has anyone successfully upgraded from 8.2 to 8.3 on an existing system who could share any insights or tips? I've tried a number of alternatives such as restoring scheme only and then data only as well as using a number of different dump_all command line options. I've been scanning the postgresql lists and site, but haven't been able to come up with anything to work with our data. Thanks, Robert Robert Soulliere Systems Librarian [email protected]<mailto:[email protected]> Tel: 905-575-1212 X3936 libr...@mohawk Connect * Learn * Succeed brain.mohawkcollege.ca<http://brain.mohawkcollege.ca/> ________________________________ This E-mail contains privileged and confidential information intended only for the individual or entity named in the message. If the reader of this message is not the intended recipient, or the agent responsible to deliver it to the intended recipient, you are hereby notified that any review, dissemination, distribution or copying of this communication is prohibited. If this communication was received in error, please notify the sender by reply E-mail immediately, and delete and destroy the original message.
