Re: pg_upgrade missing

To bring some closure:

I installed the -contrib as well which gave me pg_upgrade.

Then I ran into a missing postgres file issue with pg_upgrade.

I realized that the rpm -ev postgresql-server-9.0.0-1PGDG.el5.x86_64
that I had run probably caused the issue so I reinstalled 9.0

Then I hit this issue and used the instructions here to get it to run.

http://archives.postgresql.org/pgsql-admin/2011-09/msg00101.php

It completed successfully.

Thanks for the help.

Matthias

From: Matthias Howell
Sent: Wednesday, June 06, 2012 11:36 AM
To: 'pgsql-novice(at)postgresql(dot)org'
Subject: pg_upgrade missing

All,

I'm trying to upgrade from postgres 9.0.0 to 9.1.4 (latest? downloaded
it today).

however, pg_upgrade is not showing in the 9.1 bin.

Here are the steps I executed:

rpm -ivh ./pgdg-centos91-9.1-4.noarch.rpm

yum install postgresql91-server which gave me a dependency error so I
ran rpm -ev postgresql-server-9.0.0-1PGDG.el5.x86_64

then

yum install postgresql91-server again and it worked.

but there is no pg_upgrade in the new bin dir.

[root(at)sociallinux bin]# pwd

/usr/pgsql-9.0/bin

[root(at)sociallinux bin]# ls

clusterdb createdb createlang createuser dropdb droplang dropuser
oid2name pg_archivecleanup pgbench pg_dump pg_dumpall pg_restore
pg_standby pg_upgrade psql reindexdb vacuumdb vacuumlo

[root(at)sociallinux bin]#

pwd

/usr/pgsql-9.1/bin

[root(at)sociallinux bin]# ls

clusterdb createlang dropdb dropuser pg_basebackup pg_controldata
pg_dump pg_resetxlog pg_test_fsync postmaster reindexdb

createdb createuser droplang initdb pg_config pg_ctl
pg_dumpall pg_restore postgres psql vacuumdb

[root(at)sociallinux bin]#

Not sure how to proceed.

Thanks

Matthias