How to Migrate to a PostgreSQL Terminology Database

Applies To

Software	Version
Acrolinx Server	Version 2.10 or later

Major Steps

There are several major steps involved in configuring Acrolinx to connect to your PostgreSQL database:

Create a database backup of your existing terminology database.
Prepare your PostgreSQL database.
Edit the Acrolinx database configuration properties.
Restore your database backup.

Creating a Database Backup of Your Existing Terminology Database

If you are migrating an existing Acrolinx terminology database to an external database, you must first create a database backup from your existing Acrolinx Server installation.

To open the database backups page:

In the Navigation Menu, click Terminology > Import and Export > Database Backups.

To create a database backup, follow these steps:

Click Create Database Backup.
Right click the Download Link that appears, and click Save Target As.

Preparing Your PostgreSQL Database

To prepare an external PostgreSQL database for storing terminology, follow these steps:

Create a new empty database on your database server with the name of your choice.
We recommend selecting UTF-8 encoding for the database as this encoding type guarantees the ability to store terms in any language.
Configure a user name and password which has full write permissions on your new database.

Editing the Acrolinx Database Configuration Properties

You can configure a connection to an external terminology database by creating an overlay of the installed persistence properties file. You update the persistence properties overlay with the connection details for your database and restart the Acrolinx Server.

To configure the Acrolinx Terminology Manager to connect to your database, follow these steps:

Stop the core server.
Open your overlay of the following file: persistence.properties

If you have not yet created an overlay of this file, create a new version of the file at the following location:

%ACROLINX_CONFIGURATION_ROOT%\server\bin\$ACROLINX_CONFIGURATION_ROOT/server/bin/

You can copy the installed version of this file from the following location:

<INSTALL_DIR>\server\bin\<INSTALL_DIR>/server/bin/

Do not edit the installed version of the file. Instead, always edit your overlay copy in the configuration directory.

Add the following properties:

terminology.dbType=POSTGRES
terminology.jdbcUser=<DATABASE_USERNAME>
terminology.jdbcPassword=<DATABASE_PASSWORD>
terminology.jdbcUrl=jdbc:postgresql:<DB_NAME>

Example:

terminology.dbType=POSTGRES
terminology.jdbcUser=termadmin
terminology.jdbcPassword=jama7UrU
terminology.jdbcUrl=jdbc:postgresql:terminology

Save your changes and restart the core server.
Check the core server log file for any errors or warnings.

Restoring your Database Backup

If you have configured the Acrolinx to connect to a different database for storing terminology and want to use existing terminology data, you must restore a database backup made from your original terminology database.

To open the database backups page:

In the Navigation Menu, click Terminology > Import and Export > Database Backups.

To restore a database backup, follow these steps:

Locate the database backup file using the Browse button.
Click Restore Database Backup.
In the security dialog which appears, enter the word yes and click OK.
Tip: This type of dialog is an extra precaution to prevent you from overwriting your terminology database unintentionally.

The import operation starts and a confirmation prompt appears when the import has completed.
Restart all servers (for more information, see the Acrolinx Server Administration Guide).
Important: If the configurations of all installed language servers are not reloaded, the term help files do not load correctly.