first of all stop postgresql
sudo /etc/postgresql9-0 stop
get latest RPM's from postgresSQL repos
i use wget to take rpm then
rpm -ivh your_postgresql_rpm.rpm yum install postgresql91.x86_64 postgresql91-contrib.x86_64 postgresql91-devel.x86_64 postgresql91-libs.x86_64 postgresql91-server.x86_64
after installation complete initialize new cluster (do not start just initdb)
sudo /etc/init.d/postgresql9.1 initdb
ok now, there is a problem in ldconfig's lets change them (details here
cd /etc/ld.so.conf.d mv postgresql-9.0-libs.conf postgresql-9.old-libs.conf ldconfig
now lets start to play with pg_upgrade
pg_upgrade has great syntax
/usr/pgsql-9.1/bin/pg_upgrade -d /var/lib/pgsql/9.0/data/ -D /var/lib/pgsql/9.1/data/ -b /usr/pgsql-9.0/bin/ -B /usr/pgsql-9.1/bin/ -v
-d old data dir
-D new data dir
-b old binary dir
-B new binary dir
and after installation complete. it's done :)
