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?