1. Connecter Help Center
  2. Administration
  3. Workspaces

Search

Suite Workspace Backup and Restore

Plamen
Plamen
  • Updated 
Feature availability 🛈
⭕ Personal ✔️ Suite

Overview

Your Suite Workspace in Connecter is a database containing information about all your actions in the desktop app. That could be adding a tag, assigning a custom preview, creating a Dynamic subset – all that and everything else is logged.

Consequently, a backup is a copy of the Suite Workspace database, stored separately from the originals. So, if something unexpected happens, you can restore your Workspace to its last backup state.

Cloud-hosted Suite Workspace Backup

Cloud Suite Workspaces are hosted on a secure server with an SSL-encrypted connection and automatically scheduled hourly backups. Our team handles this setup and the restore from backup, when necessary, so you have nothing to do.

Every change to your Workspace is logged and backed up. If anything happens and you need to restore your Workspace to its previous state, you can contact our support team, and they'll handle it for you. 

Self-hosted Suite Workspace Backup  

With a self-hosted Suite Workspace, every organization decides how to handle the Workspace hosting, and depending on its operating system and deployment tools, backup and restore processes vary.

Here's a backup process example for Windows, using a PostgreSQL server and the database management tool pgAdmin:

  • Open pgAdmin and log in with an account with access to the database you want to backup – your Suite Workspace.
  • Right-click on the database and select “Backup” from the contextual menu.

  • A dialog will open, and you’ll need to do the following in the General tab:
    • Configure the “Format” and “Encoding.” 
    • Select a file on the disk in the “Filename” field for the backup.
    • Press the “Backup” button.

  • The next step is optional. You can configure the database backup to be performed without saving the Database Owner with it. That’ll require an additional step to set the Owner when you Restore the database from a backup. 

 Performing a backup without the Owner will make it easier to transfer the database to another server     where the Owner doesn’t exist.

Keep in mind that the backup process will be different for other servers and database management tools.

How to restore from backup?

As for how to recover your Workspace from backup with this setup, here's the list of steps to follow:

  • Open pgAdmin and log in with an account with access to the database you want to restore from backup.
  • Right-click on the database and select “Restore” from the contextual menu.

  • Configure the “Format” and select a backup in the “Filename” field and press the “Restore” button.

  • The next step is optional. If the database backup was performed with the “Do not save Owner” option, the database won’t have the required Owner set. You have to set it manually. In that case, you’ll have to:
    • Right-click on the database and select “Properties” from the contextual menu.

  • Set the “Owner” field in the dialog and press “Save.”

Here are some more additional resources you may find useful for this setup: