Pervasive database migration/upgrade
Posted on 2014-10-31
We're having a lot of issues with a couple of our psql servers and are going to upgrade.
Current: Windows 2003 standard x86, v9.x psql
New: Windows 2008 standard x64, v11.x psql
Both environments are virtual on vmware ESXi 5.1. My plan for migration is to shut down the old servers, detach the data drive, and attach it to the new server.
My question is: Can the new psql just attach this database as is or would it be a better plan to attach the old data drive and a same size new data drive and do some kind of import activity?