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 or the Oracle schema that will store your data

  • The credentials required to connect to the database backend

  • If you are using PostgreSQL, the Squore custom library (Prerequisites for PostgreSQL)

The installer requires that the specified user and database already exist, so it can connect and initialise the database using the details provided.

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.

Prerequisites for Oracle

When using Oracle as a database backend, a database administrator must create an Oracle user before you can install Squore.

The user requires a valid quota for the tablespace used by the user (for example UNLIMITED), and the following privileges:

  • CREATE PROCEDURE

  • CREATE SEQUENCE

  • CREATE SESSION

  • CREATE TABLE

  • CREATE TYPE

  • CREATE VIEW

Prerequisites for PostgreSQL

When using PostgreSQL as a database backend, a database administrator must create a PostgreSQL user before you can install Squore.

The user requires all privileges on the database:

GRANT ALL PRIVILEGES ON DATABASE "squore" TO "user"

Then 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.

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.