Using a Remote Database

It is possible to install PC-lint Plus View server and use a database running on another machine. In this mode, PC-lint Plus View 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 PC-lint Plus View 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 PC-lint Plus View, consult Backing-Up PC-lint Plus View Data.

Deploying custom library

For the remote database to work with PC-lint Plus View, 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 <PCLPVIEW_HOME>/tools/pgsql/lib folder and is named squore.so.XXX.

  • Windows: it will be provided by PC-lint Plus View 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 PC-lint Plus View.