On 10/10/2012 09:56 AM, Bruce Momjian wrote: > Can you show me what is in the PG_VERSION file in the old cluster? It > should be "9.1". Hi Bruce, Thank you for the reply. Indeed it is "9.1": # cat /postgresql/9.1/main/PG_VERSION 9.1 And just for good measure: cat /postgresql/9.2/main/PG_VERSION 9.2 And there are no other PostgreSQL versions on this machine. Hmm... I was just about to send this when something else occurred to me. I had initially tried to run pg_upgrade as root and it said it couldn't be run as root. So I've been running it as my own user (which is in the postgres group). However, everything in /postgresql/9.1/main is owned by postgres with 700 permissions. I switched to the postgres user and now pg_upgrade is running. Perhaps just a more informative error message is in order. Thank you for the shove in the right direction =) Cheers! - Chris -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
