Page 1 of 1

Supported PostgreSQL

PostPosted: Mon Nov 05, 2012 3:11 pm
by 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?

Re: Supported PostgreSQL

PostPosted: Mon Nov 05, 2012 5:09 pm
by kraada
The latest version we support is 9.0.10, but you would need to migrate manually. Are you running 64-bit Windows?

Re: Supported PostgreSQL

PostPosted: Mon Nov 05, 2012 5:49 pm
by 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?!

Re: Supported PostgreSQL

PostPosted: Mon Nov 05, 2012 6:22 pm
by 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.

Re: Supported PostgreSQL

PostPosted: Mon Nov 05, 2012 7:24 pm
by m4ximu5
Does the same approach be valid for an update from PT4\Windows XP\PostgreSQL 8.3 ---> PT4\Windows 7 \ PostgreSQL 9.0x64?

Re: Supported PostgreSQL

PostPosted: Tue Nov 06, 2012 4:15 am
by WhiteRider
Yes - our backups and database conversion is not version-specific.

highfalutin