Hello,
I have the following scenario, I would like to upgrade a database server from 8.3 to 9.1. The upgrade includes also a hardware upgrade.
I would like to have the following
1. Make sure that the upgraded server and the old server have the same snapshot of data.
2. Make sure that the old server data is accessible for read only after taking the data snapshot until making the new server alive and tested
The lock database command is not yet implemented, so what are the ways to hack this command. Also, I need to make sure that the server is down for very short time, so is there a better way than using pg_dump and pg_restore for different database server versions ?
Regards