Hi,
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
Hi!
GOMBAS Gabor [2005-03-23 14:32 +0100]:
However I'm now reasonably confident that this is the result of this line
in (some) old postgresql postinst:
/sbin/start-stop-daemon --chuid postgres --name enable_lang --startas
/usr/lib/postgresql/bin/enable_lang --start -- plpgsql --all
Package: postgresql-common
Version: 3
Severity: normal
Tags: experimental
Hi,
The line
use lib /usr/share/postgresql-common
is missing from the beginning of /usr/bin/pg_upgradecluster. If I add it
and try to migrate a database from 7.4 to 8.0 using
pg_upgradecluster 7.4 transition
I get
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
Hi!
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).
The output of pg_dumpall includes the following repeated for every
database being dumped:
CREATE FUNCTION plpgsql_call_handler()
Hi Gabor!
Gabor Gombas [2005-03-22 16:32 +0100]:
use lib /usr/share/postgresql-common
Fixed in arch HEAD, will upload soon.
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:
6 matches
Mail list logo