Supported PostgreSQL

[vodri]

I have now PT3 with PostgreSql 8.3.9. I upgrade my PT3 license to PT4.
Before I install PT4 should I install latest PostgreSQL software? What is the latest supported PostgreSQL version? 9.2.1 or only 9.0.10?
How can I migrate PT3 database (8.3.9) to PT4(9.2.1 or 9.0.10)? Does the PT4-Setup Assistant do it?

[kraada]

The latest version we support is 9.0.10, but you would need to migrate manually. Are you running 64-bit Windows?

[vodri]

Yes, I use 64-bit Windows 7.
What does manually migrate mean? Backup up from PostgreSQL (8.3.9) and restore to PostgreSQL (9.0.10)?
After it, Do I install PT4? But PT4 create a new database?!

[kraada]

The easiest thing to do is probably to install 9.0 x64 while 8.3 is still installed - these can run side by side, so just specify a different port during the 9.0 installation (5433 will work well), then make sure when you connect to PostgreSQL using PT4 that you use that port in the connection. You can find 9.0x64 for download here.

Then when you go to import your PT3 database into PT4 just specify the old port (5432) and it'll detect your PT3 install and move everything over. Once you've got everything moved over you can uninstall PostgreSQL 8.3 and everything will be set.

[m4ximu5]

Does the same approach be valid for an update from PT4\Windows XP\PostgreSQL 8.3 ---> PT4\Windows 7 \ PostgreSQL 9.0x64?

[WhiteRider]

Yes - our backups and database conversion is not version-specific.