Managing Cubit Estimating Database Backups and Schedules

Follow

Cubit Estimating Management Console

When on a network version there is usually a desktop shortcut to access Cubit Estimating Management console. The shortcut can also be accessed from C:\Program Files\Buildsoft\Cubit folder (Right Click on Cubit Estimating Icon and Open File Location).

                              2.png

Fig 1. File Location

1.png

Fig 2. Cubit Estimating Management Shortcut

Configure and Schedule

To configure a database backup you will need to start Cubit Estimating Management Console as an Administrator.

1. Right click on the icon and then select Run as Administrator

2. Click on the Configure button to set up.

This opens a Backup settings window. here you can specify the following options which need to be set up for a backup to be taken correctly.

  • PostgreSQL install directory: You will need to identify what version of Cubit you have installed as this will affect this field.
    If you are using a 64-bit machine you will need to look at folder; C:\Program Files\Postgresql
    If you are using a 32-bit machine you will need to look at folder; C:\Program Files (x86)\Postgresql
    Within the Postgresql folder there will be another folder named either '9.2' or '10'.
    Once you have identified what numbered folder you have you can then set this field to the following based off your configuration;

    64-bit + 10: C:\Program Files\Postgresql\10\bin
    64-bit + 9.2: C:\Program Files\Postgresql\9.2\bin

    32-bit + 10: C:\Program Files (x86)\Postgresql\10\bin

    32-bit + 9.2: C:\Program Files (x86)\Postgresql\9.2\bin

  • Backup directory: The Backup directory can be set any desired accessible location.

  • Number of Backups: This number specifies the No of Old Backups to be kept in the backup location. In the below example, the older backups are removed to ensure that there is always only 6 Backup files saved.

  • Schedule Backups: Set Frequency and date time for the backup to run automatically. It is important to make sure the database is available for the Backups to run at that specified time.


Fig 3. Backup Settings

Manual Backup

A forced database backup can be run any time by clicking the Backup button on the main screen. The Restore button will restore the Backed up Database.

NOTE: Restored database will overwrite the existing data. It is very important to make sure that you are restoring from a valid backup as this action cannot be undone.

It’s also important to ensure that you are restoring a database that is the same version of your program to ensure complete compatibility.

4.png
Fig 4. Cubit Management Console

 

References:

Cubit Estimating Database Connection Details

 

1 out of 1 found this helpful

Comments

5 comments
  • Thanks Savitha for your help...

    0
    Comment actions Permalink
  • Coming up as exception occurred

    0
    Comment actions Permalink
  • There seems to be a flaw in the logic here in the statement "It’s also important to ensure that you are restoring a database that is the same version of your program to ensure complete compatibility.".

    The database would always be in the version prior to a program version update. Assuming I backup before performing an update (which is recommended), and then there is an issue with the update that causes all my data to be deleted. This would suggest that I can't restore my data to the updated version. Isn't the point of the backup to provide a fallback in the event that there is a problem with updating the version?

    0
    Comment actions Permalink
  • Hi Mike, Thank you for your comments.
    I can understand your concerns, however, there will be no need to restore the database if an update is successful. Both the software and the database will be updated as needed.

    We have never come across such situation but in case it so happens that the data is lost during an update, reverting back to the previous version will be the best way to proceed and to understand the root cause of the problem.

    Also, the database backup is mostly used in case of system crashes or when migrating the database from one device to another.
    I hope this helps.
    Regards

    0
    Comment actions Permalink
  • Thanks Savitha for your assistance - Lindsay

    0
    Comment actions Permalink

Please sign in to leave a comment.