Your message dated Sun, 24 Oct 2010 15:42:20 -0400
with message-id <[email protected]>
and subject line Re: Bug#597600: postgresql-9.0: pg_upgrade fails because it
can't find pg_upgrade_support.so
has caused the Debian Bug report #597600,
regarding postgresql-9.0: pg_upgrade fails because it can't find
pg_upgrade_support.so
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
597600: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=597600
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-9.0
Version: 9.0.0-1
Severity: important
I just installed postgresql 9.0 from sid, installation went fine but when I try
to run
pg_upgrade to upgrade a postgres 8.4 cluster I get the following error:
/usr/lib/postgresql/9.0/bin/pg_upgrade -d /var/lib/postgresql/8.4/main -D
/var/lib/postgresql/9.0/main -b /usr/lib/postgresql/8.4/bin -B
/usr/lib/postgresql/9.0/bin -v
Running in verbose mode
sh: /usr/lib/postgresql/8.4/bin/pg_config: No such file or directory
sh: /usr/lib/postgresql/9.0/bin/pg_config: No such file or directory
Performing Consistency Checks
-----------------------------
Checking old data directory (/var/lib/postgresql/8.4/main) ok
Checking old bin directory (/usr/lib/postgresql/8.4/bin) ok
Checking new data directory (/var/lib/postgresql/9.0/main) ok
Checking new bin directory (/usr/lib/postgresql/9.0/bin) ok
pg_upgrade_support.so must be created and installed in
/pg_upgrade_support.so
Please note that, although not visible in the above pasted output, the error
line I see in the terminal
looks like the following:
pg_upgrade_support.so must be created and installed in [0006]pgrade_support.so
[0006] represents a non ascii character which I see as a square containing the
numbers 0006 on
two lines (if it's not clear I can send you a screenshot).
Please, let me know if you need more information.
Regards,
Paolo.
-- System Information:
Debian Release: squeeze/sid
APT prefers testing-proposed-updates
APT policy: (500, 'testing-proposed-updates'), (500, 'testing'), (100,
'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core)
Locale: LANG=en_SG.UTF-8, LC_CTYPE=en_SG.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages postgresql-9.0 depends on:
ii libc6 2.11.2-5 Embedded GNU C Library: Shared lib
ii libcomerr2 1.41.12-2 common error description library
ii libgssapi-krb5-2 1.8.3+dfsg~beta1-1 MIT Kerberos runtime libraries - k
ii libkrb5-3 1.8.3+dfsg~beta1-1 MIT Kerberos runtime libraries
ii libldap-2.4-2 2.4.23-5 OpenLDAP libraries
ii libpam0g 1.1.1-6 Pluggable Authentication Modules l
ii libpq5 9.0.0-1 PostgreSQL C client library
ii libssl0.9.8 0.9.8o-2 SSL shared libraries
ii libxml2 2.7.7.dfsg-4 GNOME XML library
ii locales 2.11.2-5 Embedded GNU C Library: National L
ii postgresql-client-9.0 9.0.0-1 front-end programs for PostgreSQL
ii postgresql-common 110 PostgreSQL database-cluster manage
ii ssl-cert 1.0.26 simple debconf wrapper for OpenSSL
ii tzdata 2010l-1 time zone and daylight-saving time
postgresql-9.0 recommends no packages.
Versions of packages postgresql-9.0 suggests:
ii pidentd [ident-server] 3.0.19.ds1-5 TCP/IP IDENT protocol server with
-- no debconf information
--- End Message ---
--- Begin Message ---
hello Paolo,
Paolo Scarabelli [2010-09-21 14:49 +0800]:
> pg_upgrade_support.so must be created and installed in
> /pg_upgrade_support.so
I just tested pg_upgrade with the current 9.0.1-1 packages, on a
manualy installed cluster (with initdb), and it worked just fine.
However, as you already noticed you'll get a lot of trouble if you try
to run pg_upgrade on a cluster which was created "the Debian way" with
pg_createcluster, i. e. with the config files in /etc and so on. I'm
afraid pg_upgrade isn't powerful enough yet to deal with those.
So you either need to use the Debian tools (pg_createcluster and
pg_upgradecluster for upgrading), or the upstream ones (initdb and
pg_upgrade).
Thanks,
Martin
--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
signature.asc
Description: Digital signature
--- End Message ---
