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@sociallinux bin]# pwd
/usr/pgsql-9.0/bin
[root@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@sociallinux bin]#
pwd
/usr/pgsql-9.1/bin
[root@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@sociallinux bin]#
Not sure how to proceed.
Thanks
Matthias