I've finally received my new virtual database server (Debian Linux) & this weekend I'll be rolling my new PostgreSQL server online. My question is I've never migrated production data from 8.4.8 to 9.1.1. I would like to find out from the community what exactly is the recommended process in moving my database server from 8.4.8 to 9.1.1. I'm not simply upgrading the existing server as I will be installing PostgreSQL 9.1 on the new hardware and not sure if it's as simple as simply performing a pg_dumpall: pg_dumpall > mydata.sql I don't know if I need to use some kind of conversion tool to convert the data from 8.4.8 so that it's compatible with 9.1.1 so if you guys could please shine in on any recommendations, I would greatly appreciate it! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
