Spire 3.10 and higher installs PostgreSQL 14 for new installations. Existing Spire servers that already have PostgreSQL 10 installed will continue using PostgreSQL 10 until the server is manually upgraded.

This article outlines the recommended process for upgrading an existing Spire server to PostgreSQL 14.


Important Notes

  • New installations of Spire 3.10 and higher automatically install PostgreSQL 14.
  • Existing Spire installations using PostgreSQL 10 are not automatically upgraded.
  • This process requires uninstalling and reinstalling the Spire Server software.
  • It is strongly recommended to perform this procedure after business hours and ensure all users are logged out of Spire.

Before You Begin

Before upgrading, complete the following preparation steps:

  1. Create an Archive of all companies on servers running Spire 3.6 or higher.
  2. Download the archive files to a local folder such as Downloads or another accessible location.
  3. Create a Snapshotof all companies.
    • Snapshots are optional for servers running Spire 3.6 or higher.
    • Creating snapshots is still recommended as an additional backup measure.

Upgrade Procedure

Follow the steps below to install PostgreSQL 14 on an existing Spire server.

  1. Uninstall the current version of Spire Server.
  2. Rename the existing Spire data folder:
    • Rename:
      C:\ProgramData\Spire
    • To:
      C:\ProgramData\Spire_Orig
  3. If the Spire program folder exists, rename it:
    • Rename:
      C:\Program Files\Spire
    • To:
      C:\Program Files\Spire_Orig
  4. Install Spire 3.10 or higher.
  5. Restore your company data using one of the following methods:
    • Import the archive files created earlier, or
    • Restore the snapshots created during preparation

After the Upgrade

Monitor the system for several days to confirm that all company data and settings are functioning correctly.

Once the upgrade has been verified, the old backup folders can be removed:

  • C:\ProgramData\Spire_Orig
  • C:\Program Files\Spire_Orig

Additional Recommendations

  • Verify that all workstations can connect successfully after the upgrade.
  • Confirm that scheduled backups are running normally.
  • Ensure any third-party integrations or custom reports are functioning as expected.