Thread: BUG #6367: Missing pg_config

BUG #6367: Missing pg_config

From
thangalin@gmail.com
Date:
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.

Re: BUG #6367: Missing pg_config

From
Robert Haas
Date:
On Fri, Dec 30, 2011 at 9:17 AM,  <thangalin@gmail.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: =A0 =A0 =A06367
> Logged by: =A0 =A0 =A0 =A0 =A0D J
> Email address: =A0 =A0 =A0thangalin@gmail.com
> PostgreSQL version: 9.1.2
> Operating system: =A0 Kubuntu Linux 10.10
> Description:
>
> 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.

I think you will need to report this to the Ubuntu folks.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company