We are moving out of our current dataserver based on Santiago, Chile to Amazon (AWS) in North Carolina, all other servers have been successfully migrated with no problem, but our "migration consultant / provider" has been struggling migrating our Postgresql server for weeks no with no relevant progress.
Our database is about 700GB big, and they seem to have speed / bandwidth problems, but I'm guessing there's much more than that.
They are actually using a product named "Double Take" to achieve the migration, but I've just read about Slony in another question when I started writing this.
Is there any way to track down / measure daily changes in database content? Thousands of records are added and several others are expired on a daily basis.
Any suggestions on perfecting the migration process would be appreciated.