I just upgraded PostgreSQL 9.1.5 to 9.2.1 on my Ubuntu 11.10 server. One thing that caused me grief for a while was that the pg_upgrade and pg_config files didn’t exist for the 9.2 installation. It took me a while to figure out that they are packaged separately in the postgresql-server-dev-9.2 package. Installing that did the trick, but it’s a little put-offish having to install a dev package on my prod server.

So steps I needed to get the software installed:

sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get install libpq-dev
sudo apt-get install postgresql-server-dev-9.2
sudo apt-get install postgresql-9.2

Followed by a very simple and straightforward pg_upgrade.