I’m on VCD 9.1 with external MSSQL 2016. I need to update to VCD 9.7. Since i want later to migrate to the VCD Appliance i have to migrate the current MSSQL DB to Postgres. But VCD 9.5 and 9.7 are quite rigid regarding Postgres version support. Only Postgres v10 and v9.5 are supported
Now…Release FAQ for 9.5 stated
>vCloud Director 9.5 is the last release to support MS SQL as the vCloud Director Database. Going forward only PostgreSQL database will be supported.
But VCD 9.7 supports MSSQL 2017 again.
But…Migrating VCD 9.1 DB from MSSQL to our Postgres cluster generates an error about version mismatch.
>WARNING: The provided target PostgreSQL database version is greater than all supported versions. Database migration may work with this version but is not supported. Supported: 10.9 Found: [9 Continue with migration anyway? [Y/N] (Default: N)y Finished clearing tables for migration. Beginning database migration.
I run Postgres v10.9. After asking support they’ve answered that if i want later to migrate VCD to the VCD appliance i should migrate to 10.6 or below – which is old and obvisouly i cant roll back the Postgres cluster…
Even if i do first the VCD 9.5 update and after that the MSSQL to Postgres Migration i run into the same issue.
Kind of stupid rigid version compatbility to Postgres….
To see the full content, share this page by clicking one of the buttons below