Database Migration

Using this option you can change the built-in database server (PostgreSQL) of Log360 to MS SQL Server or another instance of a PostgreSQL Server.

Important points to remember

Prerequisites for MSSQL migration

Prerequisites for PostgreSQL migration

  1. Open the remote machine where the product is installed & navigate to Product Home\ pgsql\ data\ pg_hba.conf
  2. Open pg_hba.conf file and add an entry of the host IP address and its subnet mask as 0.0.0.0/0 (Refer Pic).
  3. Prerequisites for PostgreSQL migration

  4. Navigate to Product Home\ pgsql\ data \ postgresql.conf
  5. Open postgresql.conf and change the Listen_addresses as '*' & remove the # in the start of the line. (Refer Pic)
  6. Prerequisites for PostgreSQL migration

Database backup for External PostgreSQL

Repeat the steps 1 to 3 from above whenever you update the PostgreSQL server.

Steps for Migration:

Note: Take a Backup/Snapshot of Log360 before proceeding with the steps (Important)

  1. Open the Command Prompt and navigate to <Log360 home\bin> (Here, Log360 home is the location where Log360 is installed).
  2. Stop Log360 by running shutdown.bat.
  3. Run the ChangeDB.bat.
  4. From the Server Type menu, select the database server you plan to switch to.
  5. If you select PostgreSQL Server, then:
  6. Prerequisites for PostgreSQL migration

  7. If you select MS SQL Server, then:
  8. Check the box next to Migrate Existing Data to copy the data from your old database to the new database.
  9. IMPORTANT: Leave this box unchecked only if you are changing the database of a fresh installation of Log360.

  10. If the MS SQL server you wish to migrate to has Force encryption enabled, check the box next to SSL connection.
  11. Click Test Connection and wait for the connection to be established.
  12. Prerequisites for PostgreSQL migration

  13. Once Test Connection has been established successfully, click Configure DB to initiate migration.
  14. Prerequisites for PostgreSQL migration