Hi,
Getting a similar error in pitti's ubuntu ppa version, and since he's the
maintainer the packages are probably not too different. Error message is
slightly different though, so added here in case it helps finding this
bug:
root@beaker:~# pg_upgradecluster 8.4 main
Stopping old cluster...
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Creating new cluster (configuration: /etc/postgresql/9.0/main, data:
/var/lib/postgresql/9.0/main)...
Moving configuration file /var/lib/postgresql/9.0/main/postgresql.conf to
/etc/postgresql/9.0/main...
Moving configuration file /var/lib/postgresql/9.0/main/pg_hba.conf to
/etc/postgresql/9.0/main...
Moving configuration file /var/lib/postgresql/9.0/main/pg_ident.conf to
/etc/postgresql/9.0/main...
Configuring postgresql.conf to use port 5433...
Disabling connections to the new cluster during upgrade...
Roles, databases, schemas, ACLs...
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.connectby(text, text, text, text, integer) does not
exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.connectby(text, text, text, text, integer, text) does
not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.connectby(text, text, text, text, text, integer) does
not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.connectby(text, text, text, text, text, integer, text)
does not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.crosstab(text) does not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.crosstab(text, integer) does not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.crosstab(text, text) does not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.crosstab2(text) does not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.crosstab3(text) does not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.crosstab4(text) does not exist
ERROR: could not access file "$libdir/tablefunc": No such file or directory
ERROR: function public.normal_rand(integer, double precision, double
precision) does not exist
ERROR: could not access file "$libdir/pg_buffercache": No such file or
directory
ERROR: function public.pg_buffercache_pages() does not exist
ERROR: function pg_buffercache_pages() does not exist
LINE 2: ...r, p.relblocknumber, p.isdirty, p.usagecount FROM pg_bufferc...
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
ERROR: relation "public.pg_buffercache" does not exist
ERROR: function pg_buffercache_pages() does not exist
ERROR: function pg_buffercache_pages() does not exist
ERROR: function pg_buffercache_pages() does not exist
ERROR: relation "pg_buffercache" does not exist
ERROR: relation "pg_buffercache" does not exist
ERROR: relation "pg_buffercache" does not exist
Fixing hardcoded library paths for stored procedures...
ERROR: function replace(bytea, unknown, unknown) does not exist
LINE 3: replace(probin, '/usr/lib/postgresql/lib', '$libdir'),
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Error: Could not fix library paths
Re-enabling connections to the old cluster...
Re-enabling connections to the new cluster...
Error during cluster dumping, removing new cluster
root@beaker:~#
This on ubuntu lucid with postgresql-common version 115~lucid etc from
pitti's ppa.
/Mattias Wadenstein
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org