One of my clients is upgrading some servers. The procedure we have took some time to get to current state, and we found some potential problems, so decided to write more about it.

On May, 12ve, Bruce Momjian committed new contrib module for 9.0 - pg_upgrage. As I understand - this is what was available before as pg-migrator. If you're not familiar with it - it's a tool that allows upgrade of $PGDATA from some ...