I am building a new server that is running PostgreSQL 8.1.11 under
RHEL5. My current 'live' server is PostgreSQL 8.0.3 under FC4 with an
FC4 8.0.3 backup server.
What I want to do is to swap the RHEL5 (ie 8.1.11) in as the live and
demote the live to backup and the backup to 'spare'. Currently, the live
databases are dumped and restored onto the backup box. Can I do the same
across the releases - ie dump the 8.1.11 and restore that dump on
8.0.3?