Hi! Gabor Gombas [2005-03-22 16:32 +0100]: > The line > > use lib "/usr/share/postgresql-common" > > is missing from the beginning of /usr/bin/pg_upgradecluster. If I add it
Whoops, thats an artifact from debugging, thanks. > and try to migrate a database from 7.4 to 8.0 using > > pg_upgradecluster 7.4 transition > > I get many times the following error: > > ERROR: could not access file "/usr/lib/postgresql/lib/plpgsql.so": No such > file or directory > ERROR: function public.plpgsql_call_handler() does not exist > ERROR: function plpgsql_call_handler() does not exist > > Despite the errors the result of the upgrade seems to be OK so far (at > least the data seems to be there). Do you use stored procedures in SQL? Apparently the database tries to load the library from it's old location (i. e. where the legacy packages stored them). Do you have any sensitive data in your db? If not, could you mail me a dump, so that I can reproduce and fix this? Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developer http://www.debian.org
signature.asc
Description: Digital signature
