When upgrading to Viewpoint 16.20.00.03 or later, the repository database must be upgraded to Postgres 9.4.
When upgrading to Viewpoint 16.50.00.00 or later, the repository database must be upgraded to Postgres 10.
This upgrade requires a new copy of the database to be created in the repository drive, so free space for a second copy of the database directory must be available before starting the upgrade.
For large databases, the conversion task can take substantial time, proportional to the size of the database files. Tests show the conversion takes approximately 20 minutes for every 100Gb of data in /data/viewpointdb.
- Check the size of the database:du -ks /data/viewpointdbExample result:
- Check the available space on the repository drive:df -k /dataExample result:
Filesystem 1K-blocks Used Available Use% Mounted on /dev/sdb 3512848256 462050224 3050798032 14% /data