Upgrading Cubit Estimating to PostgreSQL 16

Important Note

These instructions are applicable only if Cubit Estimating is the ONLY application using the PostgreSQL installation. If any other applications use PostgreSQL, following these instructions will disrupt their functionality.

Preparations

Backup Your Data

1. Backup Cubit Estimating Database: Use the Cubit Estimating Management Console to back up your database to prevent any data loss during the upgrade process.
   • For detailed instructions, refer to the documentation or contact Support.
2. Check Data Folder Size:
   • Check the size of C:\Program Files\Postgresql\version#\Data Folder.
   • Ensure available disk space is 2.5 to 3 times the size of this folder.

Time Required

• A 10GB database takes approximately 30 minutes to back up.
• These instructions are designed for upgrading from PostgreSQL version 10 to 16. If you have an older version, please raise a support ticket.

Download Necessary Software

1. PostgreSQL 16: Download from the official PostgreSQL website.
2. Cubit Estimating v12: Download from the distributed email from Buildsoft.

 

Installation

Short Installation Steps

1. Create a Cubit Management backup
2. Install Cubit Estimating v12.
3. Stop and disable the old PostgreSQL service.
4. Install PostgreSQL version 16.
5. Remove and recreate the database in Cubit Estimating Management Console v12.
6. Clear and restore the database backup using Cubit Management Console v12.
7. Check and apply the Upgrade in Cubit Management Console v12
8. Run Cubit Estimating v12 to ensure everything is functioning correctly.

Detailed Installation Steps with Screenshots

1. Create a Cubit Management backup from your Cubit Server or Standalone install.

• Right-click on your Cubit icon and select Open file location
• Right-click on “CUBIT Management” or “CUBIT Management.exe” and select Run as an Administrator
• Click Backup

2. Install Cubit Estimating v12

Follow the standard installation procedure for Cubit Estimating v12.

3. Stop and Disable the Old PostgreSQL Service

• Open Services:
  • In the Windows taskbar search box, type Services.
  • Right-click on Services and select Run as administrator.

• Locate PostgreSQL Service:
  • Scroll down to the PostgreSQL service (name starts with “Postgres-”).
  • Right-click on the PostgreSQL service and select Properties.

• Modify Service Properties:
  • Click Stop to stop the service.
  • Change Startup type to Disabled.
  • Click Apply and then OK.

4. Install PostgreSQL Version 16.

Follow the instructions provided on the official PostgreSQL website for installation.

Note: Accept default settings.

5. Remove and Recreate the Database in Cubit Estimating Management Console v12.

1. Create a New Database:
   • Open Cubit Estimating Management Console.
   • Highlight the existing database and click Remove.
   • Click Create, then Default.
   • Fill in the Create Database dialog based on your installation type, then click Create.

Standalone Install:

Server

Server: 127.0.0.1

Port: 5432

Existing database: postgres

Admin account: postgres

Password: p#5tgR3s*p

Database to be created

Database: buildsoftStandalone

Application account: standaloneBuildsoftUser

Password: pass4Buildsoftuser

Confirm password: pass4Buildsoftuser

Network Install:

Server

Server: 127.0.0.1

Port: 5432

Existing database: postgres

Admin account: postgres

Password: p#5tgR3s*p

Database to be created

Database: buildsoft

Application account: buildsoftuser

Password: Buildsoftuserpassword

Confirm password: Buildsoftuserpassword

6. Restore Database Backup:

• In the Cubit Management Console, highlight the database name.
• Click Configure

• Change the PostgreSQL install path directory from C:\Program Files\Postgresql\10\bin to C:\Program Files\Postgresql\16\bin.
• Click OK

• Click Restore

• Browse to select the backup file created in the initial step.
• Click the down arrow on Restore and select Clear and Restore.

• Confirm the prompt indicating the database will be cleared before the restore begins.
• Click Clear and Restore
• If a backup failure message appears, click OK  to continue.

• If a message appears about a failed backup, click Restore

• If a message appears about the backup file being a different version, click Restore.

• A final message will indicate restore completion.

7. Check and apply the Upgrade in Cubit Management Console v12

• If you have restored a Cubit Management backup generated from an earlier version of Cubit, you may need to apply outstanding patches. This can be checked by clicking Upgrade

• A list of Available Patches will be displayed. Click Upgrade

• The message The database is up to date will be displayed if the database is up to date.
• Click Close

 

Final Steps

1. Run Cubit Estimating v12:
   • Ensure everything is functioning correctly.
2. Optional Cleanup:
   • Uninstall the earlier version of PostgreSQL.
   • Delete Postgresql/10/Data to free up disk space.