Unfortunately a bug was introduced in PostgreSQL v9.4.23, v9.5.18, v9.6.14, v10.9 and v11.4, all of which were released on 20-Jun-2019. The specific bug was introduced by the release note item:
The bug has already been fixed and is just waiting on the next release of PostgreSQL which is due out in early August 2019."Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint (Tom Lane)".
However due to this PostgreSQL bug, new installations of TimeTrex, or upgrades from TimeTrex versions prior to v11.0.0 will error out with a database failure.
To work around this issue on Ubuntu 18.04, you can easily downgrade to an earlier version of PostgreSQL, complete the install/upgrade of TimeTrex, then upgrade back to the latest version again.
To do this simple download the attached postgresql-10.3-ubuntu-18.04.zip file, upload it to your Ubuntu server, then run the following commands:
Once the above is completed, install/upgrade TimeTrex, confirm it working as expected, then run "apt upgrade" to upgrade back to the most recent version of PostgreSQL.
Code: Select all
unzip postgresql-10.3-ubuntu-18.04.zip cd postgresql-10.3-ubuntu-18.04 ./downgrade.sh