Switching from Installed PostgreSQL 16 to Bundled PostgreSQL 13

Refer to the Switch Repository Dump section for detailed instructions on compatible dump preparation.

• Remove unsupported parameters such as: LOCALE_PROVIDER = libc

• Import the modified Kyvos Manager and Kyvos database dumps into the respective databases of the bundled PostgreSQL 13 service.

• TLS Configuration (If Applicable): If TLS is enabled in the deployed cluster using the installed PostgreSQL, perform the following steps to reconfigure TLS for the bundled PostgreSQL:

  1. Copy the certificate files server.crt and server.key from <installed_pg_data_dir> to <bundled_pg_base_path>/postgres/data/ to reconfigure TLS for the bundled PostgreSQL:

  2. Change ownership of these files to the Kyvos cluster deployment user using sudo chown <kyvos_user>:<kyvos_user> <file_name>

  3. Enable SSL in the bundled PostgreSQL configuration file (postgresql.conf)

  4. Update the following properties in postgresql.conf:

     ssl_cert_file = '<certificate_file_name>' ssl_key_file = '<key_file_name>'

• Restart the bundled PostgreSQL service after making the above changes.

• Update the Kyvos Manager jdbc.properties file as follows: installedRepo=false

• Ensure all bundled PostgreSQL group-related properties are correctly updated, particularly: homePathBundledRepo=/data/kyvos/app/postgres/

1. On the KM node, update the <KYVOS_INSTALL_PATH>/kyvosmanageragent/conf/services/Kyvos.xml file. In the file, change <type>ps</type> to <type>pid</type> for the PostgreSQL service. If the parameter pidFile is not already present, add it under the PostgreSQL service section:

   <param> <name>pidFile</name> <value>/data/kyvos/app/kyvos/postgres/data/postmaster.pid</value> </param>

   Here, <KYVOS_INSTALL_PATH> is /data/kyvos/app/.

2. Stop the bundled PostgreSQL service if it is already running, to ensure clean configuration reload.

3. Start the Kyvos Manager service.

4. In the kyvos/postgres/bin/kyvos-pg-back.sh file, update the parameter, POSTGRESS_INSTALLATION_TYPE=BUNDLED. Apply on all nodes, or at least on the Kyvos Manager node.

5. In the DemoDBRepository.xml file, update the PostgreSQL version to 13.

6. Push the following snapshots from Kyvos Manager:

   • BI Connection configuration

   • Kyvos Manager data

   • disaster-recovery.sh

7. Post-Migration Step: If required, update the Kyvos Manager repository and Kyvos repository passwords from their default values (set earlier in Step 1) using the Kyvos Manager.