Did you install the various languages and such before hand like you
are doing a fresh install? I would imagine that the dump commands
would not always do that for you for a number of reasons.
One idea would be to set up an empty database like you were starting
over, then dump your data into it once that works.
Thomas Berezansky
Merrimack Valley Library Consortium
Quoting "Soulliere, Robert" <[email protected]>:
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.
