Page Comparison

...

1. Login to the AWS console.

2. Navigate to RDS. On the RDS page, click Databases in the left pane.

3. On the Databases page, click Create database.

   

4. Create a new Database instance as per the below settings:

   1. Use Postgres version 13.5.

   2. Provide the name of the DB Database Instance.

      Image Added

   3. Provide the Master username as kmdbuser for the Kyvosmanager Kyvos Manager DB Instance.

   4. Provide a password for the Database. (use default password kyvosmanager#123)

   5. Use db.t3.large as the instance type for the KM DB instance.

      Image Added

   6. Specify the Storage.

      Image Added

   7. Create a new security group.

      Image Added

   8. Expand the Additional configuration and change the port from 5432 to 45421.

   9. Provide the database name as kmrepo.

      Image Added

      
      

Kyvos Manager RDS Creation and Migration

...

1. To create RDS, perform steps from 1 to 3 as mentioned in the ‘Creating Amazon Relational Database Service (RDS)’ section.

   1. Use database name as delverepo.

   2. Use the database user name as postgres.

   3. Use the same security group that is created for the Kyvos Manager RDS.

   4. Port will be same as 45421.

2. To take the Database dump for Kyvos Database:

   1. Navigate to /data/kyvos/app/postgres/bin/

   2. Execute the following below commands:
      ./pg_dump -c -C --host=localhost --port=45421 --dbname=delverepo --user=postgres--file /tmp/delverepo.sql

   3. Validate that the created file must have content.

   4. Restore the Kyvos database dump using the following command:
      ./psql -U postgres -p 5432 -h cbre-kyvos.ctdjrop6598x.us-east-1.rds.amazonaws.com -d delverepo -f /tmp/delverepo.sql

   5. Once done, connect to Kyvos RDS using the following commands and make sure the database is restored.
      ./psql -h <endpoint_of_kyvos_RDS> -p 45421 -U postgres -d delverepo \dt+

   6. Once done, navigate to Kyvos Manager > Utilities > Manage Kyvos Repository.

   7. Click External repository.

   8. Provide the repository identifier and click Fetch. It will automatically fill the details.

   9. Click Test.

   10. Once the test connection is successful, click Save.