Installing PostgreSQL

Installing PostgreSQL

The installation of the PosgreSQL database management engine is fast and simple. You can get a database server up and running in about a minute.

  1. Go to the PostgreSQL website (https://www.postgresql.org/download/windows/).
  2. Select Download the installer and choose the correct installation package (according your operating system). Depending on operating system, you will see different instructions for installation.
  3. Run installer and follow the procedure for installation.

    On the component selection step, you can remove Stack Builder:
  4. During installation select admin password, as it will be required to connect SDL Trados Business Manager to PostgreSQL server.
  5. Leave default port:
  6. Proceed to finish installation.

PostgreSQL configuration

After installation, it may be required to open the PosgreSQL port (5432 by default) in the Windows Firewall.

Important. It is highly recommended to open C:\Program Files\PostgreSQL\11\data\postgresql.conf file and set idle_in_transaction_session_timeout parameter. To do this, remove leading # symbol to uncomment it, and set some value instead of zero, for example 5000, which corresponds to 5 seconds. After changing this value, please restart PostgreSQL server from the Services console (or by restarting computer).

Connecting TBM to PostgreSQL server

  1. Open configuration page (https://localhost/Config).
  2. Select PostgreSQL in the Database system field.
  3. Specify server name (localhost), port if needed, database name (will be created automatically) and additional parameters as needed (see PostgreSQL official documentation).
  4. Click Save.
  5. Go to login page and try to logon as default user (Admin, User@TBM). If connection parameters are specified correctly, you will see dashboard page. Otherwise, you will get an error. Usually error message says why connection has failed (for example, misspelled server name or password).

Database backup

  1. After installation, run the pgAdmin 4 utility, which was installed along with the server. It may look like:
  2. Enter your password and confirm that server works correctly. Enter the prerequisites here (optional).
  3. From within SDL Trados Business Manager, you can create and restore backups only when the program in local mode. With network mode, backups are created using corresponding database engine (PostgreSQL, in this case).
  4. Expand server - Databases - find your database, right click on it and select Backup.
  5. Specify file name, select compression ratio if your database file size is large enough, and select Backup.

Database restore

To restore database from backup, follow these steps:

  1. Open pgAdmin utility and delete database you wish to restore.
  2. Create an empty database with the same name.
  3. Right-click on the created database and select Restore.
  4. In the shown dialog, specify backup file location and select Restore.
  5. After the restore operation completes, you can connect to the restored database.
Related
Recommended