Using a Remote Database

It is possible to install Squore server and use a database running on another machine. In this mode, Squore server does not manage the database startup and shutdown, and database backups must be performed manually.

If you plan on performing such an installation, ensure that you have access to the following information:

  • The IP address or hostname of the server where the database is running

  • The port that the database is listening on

  • The name of the PostgreSQL database schema that will store your data

  • The credentials required to connect to the database backend

  • The Squore custom library (Deploying custom library)

When performing backups, ensure that you back up the database and the project folder at the same time so that you can restore a coherent snapshot of your data. For more information about backups in Squore, consult Backing-Up Squore Data.

Deploying custom library

For the remote database to work with Squore, a custom library needs to be deployed in your PostgreSQL installation. Retrieving the custom library will depend on the OS you are using:

  • Linux: it is located in the installation archive, in <SQUORE_HOME>/tools/pgsql/lib folder and is named squore.so.XXX.

  • Windows: it will be provided by Squore support, you can contact us at support@vector.com.

Then to deploy the library, choose one of the two following methods:

  • Method 1:

    1. Copy the according file in the lib folder of your PostgreSQL installation.

    2. Rename the file as squore.so (Linux) or squore.dll (Windows).

  • Method 2:

    1. Copy the according file in a folder of your choosing, accessible by your PostgreSQL installation.

    2. Rename the file as squore.so (Linux) or squore.dll (Windows).

    3. Append chosen folder path to the dynamic_library_path parameter in <CLUSTER_DIR>/postgresql.conf file.

    4. Reload PostgreSQL cluster configuration by executing command:

      • <postgres-installation-folder>/bin/pg_ctl reload -D <CLUSTER_DIR>

Make sure you deploy this custom library before installing/upgrading Squore.