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.
When upgrading to Viewpoint 23.10.00.00 or later, the repository database must be upgraded to Postgres 14.
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.
If do not have enough space, contact your system administrator to provide more free space. If you cannot free up enough space, contact your Customer Service Representative.
- Check the size of the database:du -ks /data/viewpointdbExample result:
144392400 /data/viewpointdb
- 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