The following bug has been logged on the website:
Bug reference: 6367
Logged by: D J
Email address: thangalin@gmail.com
PostgreSQL version: 9.1.2
Operating system: Kubuntu Linux 10.10
Description:=20=20=20=20=20=20=20=20
REPLICATE
1. Clean OS.
2. Use "synaptic" to install postgresql-8.4 packages.
3. Install a database into /home/postgres/8.4/main
4. Add PPA for pitti.
5. Use "synaptic" to upgrade postgres-8.4 packages to postgresql-9.1.
6. Stop both the databases (/etc/init.d/postgresql stop).
7. Run pg_upgrade:
/usr/lib/postgresql/9.1/bin/pg_upgrade --link
--old-datadir=3D/home/postgres/8.4/main --new-datadir=3D/home/postgres/9.1/=
main
--old-bindir=3D/usr/lib/postgresql/8.4/bin
--new-bindir=3D/usr/lib/postgresql/9.1/bin
EXPECTED RESULTS
The 8.4 database is upgraded to 9.1 using a hard link.
ACTUAL RESULTS
check for /usr/lib/postgresql/9.1/bin/pg_config failed - No such file or
directory
SYSTEM DETAILS
$ locate pg_config
/usr/bin/pg_config
/usr/include/postgresql/pg_config.h
/usr/include/postgresql/pg_config_manual.h
/usr/include/postgresql/pg_config_os.h
/usr/include/postgresql/8.4/server/pg_config.h
/usr/include/postgresql/8.4/server/pg_config_manual.h
/usr/include/postgresql/8.4/server/pg_config_os.h
/usr/lib/postgresql/8.4/bin/pg_config
/usr/share/locale-langpack/en_GB/LC_MESSAGES/pg_config-8.4.mo
/usr/share/man/man1/pg_config.1.gz
/usr/share/postgresql/8.4/man/man1/pg_config.1
/usr/share/postgresql-common/t/140_pg_config.t
$ uname -a
Linux jaguar 2.6.35-30-generic #54-Ubuntu SMP Tue Jun 7 18:41:54 UTC 2011
x86_64 GNU/Linux
$ psql --version
psql (PostgreSQL) 8.4.9
$ which psql
/usr/bin/psql
$ /usr/lib/postgresql/8.4/bin/psql --version
psql (PostgreSQL) 8.4.9
$ /usr/lib/postgresql/9.1/bin/psql --version
psql (PostgreSQL) 9.1.2
contains support for command-line editing
ADDITIONAL INFORMATION
It also appears as though the header files are not cleanly installed. It
looks like the 8.4 header files do not use symbolic links.
