14.2 Back Up Data from the PTM Database

The PTM database on your existing PlateSpin Migrate 2019.2 Appliance uses PostgreSQL version 9.6 on the SUSE Linux Enterprise Software (SLES) 12 SP3 operating system. For the PlateSpin Transformation Manager 2019.5 Appliance, the PTM database uses PostgreSQL version 10 on the SUSE Linux Enterprise Software (SLES) 15 operating system. For this upgrade, you will export the data from the existing PTM database, and then import it later on the replacement Appliance.

To export the PTM database from PostgreSQL 9.6 on the old Appliance:

  1. Stop all PTM and Migrate Connector activities on the PTM Appliance by performing prerequisite Task: Requirements through Task: Admin in Table 14-1, Checklist for Preparing to Upgrade the PTM Appliance.

  2. Establish an SSH session with the PlateSpin Transformation Manager 2019.2 Appliance VM.

  3. Log in as the root user.

  4. Get the count of transformations in the current PlateSpin Database. In a console, enter

    su postgres -c "psql -d transmgr -c 'select count(*) from tm.trans'"

  5. In a text editor, change the /product/version XML-node in /etc/products.d/baseproduct from 2019.2 to 12.3.

    The version 12.3 refers to SUSE Linux Enterprise Server 12 SP3, which is used by PostgreSQL 10 repo for platform versioning.

  6. Back up the current PTM database by dumping the database to the /vastorage/ptm folder. Enter

    su postgres -c "/usr/pgsql-10/bin/pg_dumpall" > /vastorage/ptm/pg_backup.sql

  7. Stop the PostgreSQL 9.6 server. Enter

    rcpostgresql stop

  8. Save a copy of the pg_hba.conf file.

  9. Make a note of any configuration settings you might have made in the postgresql.conf file.

  10. Continue preparing for upgrade with the next task in Table 14-1, Checklist for Preparing to Upgrade the PTM Appliance.