{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Applies to","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Enterprise ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Cloud (SaaS on AWS) ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}},{"text":" Kyvos AWS Marketplace","type":"text"}]},{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}},{"text":" Kyvos Azure Marketplace ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}},{"text":" Kyvos GCP Marketplace ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}},{"text":" Kyvos Single Node Installation (Kyvos SNI) ","type":"text"}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"The section provides information on the following: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Important points ","type":"text","marks":[{"type":"link","attrs":{"href":"https://cleartrail.atlassian.net/issues/NEWUX-47253?filter=29881"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Using Database dump commands","type":"text","marks":[{"type":"link","attrs":{"href":"https://cleartrail.atlassian.net/issues/NEWUX-47253?filter=29881"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Switching repository ","type":"text","marks":[{"type":"link","attrs":{"href":"https://kyvosdocumentation.atlassian.net/wiki/spaces/KD20253/pages/380416674/Switching+Kyvos+Repository#Switching-repository"}}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Important points ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"important"},"legacyAnchorId":{"value":"SwitchingKyvosRepository-important"}},"macroMetadata":{"macroId":{"value":"839773cfeaa695a4b73198cb1486aebfc0a0e058428270ad226c9e7cd0944ea8"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"08c2cfa3-b364-4456-919c-7532822d43d2"}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"You can see the last operation details, including progress status and start time, by clicking the ","type":"text"},{"text":"i","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" icon. To view more comprehensive details, simply click the ","type":"text"},{"text":"View Details","type":"text","marks":[{"type":"strong"}]},{"text":" link, which will take you to the ","type":"text"},{"text":"Operations","type":"text","marks":[{"type":"link","attrs":{"href":"https://kyvosdocumentation.atlassian.net/wiki/spaces/KD20253/pages/380414146"}}]},{"text":" page, where you can view the operation information in detail. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To avoid semantic model data loss, ensure that before switching ensure property “OBSOLETE_CUBE_PURGE_FREQUENCY“ is set in olapengine.properties by increasing the value for it to desired frequency value in which verification that switching worked well can be complete.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the target repository password is different then only for connection testing purposes password can be specified in provided optional input. If not specified explicitly, Kyvos Manager will use the existing password configured in the system for validating the connection. This is not applicable to GCP. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Before switching the repository ensure that you have data ready in the target Postgres instance to which you are switching.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Dump import and export can be done using ","type":"text"},{"text":"pgdump","type":"text","marks":[{"type":"strong"}]},{"text":" and ","type":"text"},{"text":"psql. ","type":"text","marks":[{"type":"strong"}]},{"text":"However, in case of external to external repository change service on the snapshot offered by the cloud can be used to take snapshot from source Postgres and restore it in destination Postgres.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Username and Password and database name in target Postgres instance to which switching to is expected to be same as that of current in-use Postgres instance.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Rollback Scenario","type":"text","marks":[{"type":"strong"}]},{"text":": If after an upgrade, the repository is switched then before performing rolling back, ensure it is switched back to the original repository.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Permissions required in role attached on Kyvos Manager node remains same as that of required for automated deployed in case of external repository thus for switching from external repository to external repository no additional permission is required in the role added on Kyvos Manager node.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For switching from bundled to an external repository, you need to add permission on the role attached to the Kyvos Manager node so that fetch or external repository details work. If permission is not added to the role, then the Fetch Details will not work. However, you can still proceed ahead by providing those details manually on provided UI inputs.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If switching to an external repository, then proper network access should be configured.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The security group must have a role granting access to the port used by external repo from BI Server and Kyvos Manager node if it is in the same region and resource group (For Azure Postgres) as that of the cluster.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Following tags are expected on the external repository:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"UsedBy - Kyvos","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ROLE - DATABASE","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"LAYER - Metadata_Storage","type":"text"}]}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Using Database import/export commands ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"commands"},"legacyAnchorId":{"value":"SwitchingKyvosRepository-commands"}},"macroMetadata":{"macroId":{"value":"0f0fd8b0f694cecb2d5e0808cad24e3924c070ea266e0f14420f3739451f16cc"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"d32fd9ec-b136-476c-8f42-0adb1ecd4343"}},{"text":" ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"export-importcommands"},"legacyAnchorId":{"value":"SwitchingKyvosRepository-export-importcommands"}},"macroMetadata":{"macroId":{"value":"7e3f693efad03f1e553fecb662c82361b72c886fb9db7c0486c521f5b0289419"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"8efc518a-0d25-407f-8ad0-e8c22240e858"}}]},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Database name is fixed and always required as ","type":"text"},{"text":"delverepo","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"For import and export, run the below commands from ","type":"text"},{"text":"kyvos/Postgres/bin","type":"text","marks":[{"type":"strong"}]},{"text":" folder of Kyvos Manager machine.","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Connect to Database from terminal ","type":"text"}]},{"type":"codeBlock","content":[{"text":"export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:{KYVOS_HOME}/Postgres/lib:{KYVOS_HOME}/Postgres/librhel8\n./psql -h -p -U ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Database dump Import","type":"text"}]},{"type":"paragraph","content":[{"text":"Before importing, if the database dump itself doesn't take care of creating database then ensure you have manually create database first using create database command","type":"text"}]},{"type":"paragraph","content":[{"text":"Execute one of the following commands: ","type":"text"}]},{"type":"codeBlock","content":[{"text":"./psql -U -p -h -d -f \n./psql -U -p -h -d < ","type":"text"}]},{"type":"paragraph","content":[{"text":"The following tables describes the sample commands. This is ONLY for reference. ","type":"text"}]},{"type":"table","attrs":{"layout":"align-start","width":1800.0,"localId":"2743175c-c868-4de4-a8bc-426ae4dcd376"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[257.0]},"content":[{"type":"paragraph","content":[{"text":"Repository ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1542.0]},"content":[{"type":"paragraph","content":[{"text":"Sample command (for Kyvos database ONLY)","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[257.0]},"content":[{"type":"paragraph","content":[{"text":"Import to bundled","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1542.0]},"content":[{"type":"paragraph","content":[{"text":"./psql -U postgres -p 45421 -h localhost -d delverepo -f db-dump.sql","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[257.0]},"content":[{"type":"paragraph","content":[{"text":"Import to external ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1542.0]},"content":[{"type":"paragraph","content":[{"text":"AWS","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"type":"hardBreak"},{"text":"./psql -U postgres -p <> -h <> -d delverepo -f db-dump.sql","type":"text"},{"type":"hardBreak"},{"text":"Azure","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"type":"hardBreak"},{"text":"./psql -U postgres -p 5432 -h kyvos-postgresserver-1010.postgres.database.azure.com -d delverepo -f db-dump.sql","type":"text"},{"type":"hardBreak"},{"text":"GCP","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"type":"hardBreak"},{"text":"./psql -U postgres -p 5432 -h 10.243.140.5 -d delverepo -f db-dump.sql","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Database dump export ","type":"text"}]},{"type":"codeBlock","content":[{"text":"./pg_dump -c -C --host= --port= --dbname= --user= --password= ","type":"text"}]},{"type":"paragraph","content":[{"text":"The following tables describes the sample commands. This is ONLY for reference. ","type":"text"}]},{"type":"table","attrs":{"layout":"align-start","width":1800.0,"localId":"79d72119-5521-4b76-8920-4db491fd245b"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[257.0]},"content":[{"type":"paragraph","content":[{"text":"Repository ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1542.0]},"content":[{"type":"paragraph","content":[{"text":"Sample command (for Kyvos database ONLY)","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[257.0]},"content":[{"type":"paragraph","content":[{"text":"Export from bundled","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1542.0]},"content":[{"type":"paragraph","content":[{"text":"./pg_dump -c -C --host=localhost --port=45421 --dbname=delverepo --user=postgres --password= dbdump.sql","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[257.0]},"content":[{"type":"paragraph","content":[{"text":"Export from external ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1542.0]},"content":[{"type":"paragraph","content":[{"text":"AWS","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"type":"hardBreak"},{"text":"./pg_dump -c -C --host= --port=45421 --dbname=delverepo --user=postgres --password= dbdump.sql ","type":"text"}]},{"type":"paragraph","content":[{"text":"Azure","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"type":"hardBreak"},{"text":"./pg_dump -c -C --host=kyvos-postgresserver-1010.postgres.database.azure.com --port=5432 --dbname=delverepo --user=postgres --password= dbdump.sql ","type":"text"}]},{"type":"paragraph","content":[{"text":"GCP","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"type":"hardBreak"},{"text":"./pg_dump -c -C \"host=10.123.230.22 port=5432 dbname=delverepo user=postgres password=\" > dbdump.sql","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Switching repository ","type":"text"}]},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Currently, in AWS, the switch repository is not working as expected; therefore, migrating a repository is not supported.","type":"text"}]},{"type":"paragraph","content":[{"text":"In the Kyvos 2025.2 release, following switching repository cases not supported: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Switching from an external repository to bundled repository","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Switching from external repository to another external repository","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"The section provides information on the following: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Switching from bundled repository to external repository","type":"text","marks":[{"type":"link","attrs":{"href":"#exttobundled"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Switching from external repository to another external repository","type":"text","marks":[{"type":"link","attrs":{"href":"#bundtoexternal"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Switching from an external repository to bundled repository","type":"text","marks":[{"type":"link","attrs":{"href":"#KyvosMigration"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Switching to a new bundled repository (recovered state) from the bundled repository","type":"text","marks":[{"type":"link","attrs":{"href":"#newbundledtonew"}}]},{"text":" (for Disaster Recovery) ","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Switching from an external repository to bundled repository","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"exttobundled"},"legacyAnchorId":{"value":"SwitchingKyvosRepository-exttobundled"}},"macroMetadata":{"macroId":{"value":"1bb01d2aa4eb18d9bc3349187289ac0f74012415158276abe972907445ce2861"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"6bfe295c-3221-4430-a1f0-221eb5e3cc1c"}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Export data from external Postgres (AWS RDS, Azure Postgres or GCP CloudSQL).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In an existing cluster, identify the target node for running bundled Postgres and start the Postgres service on that target node.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the navigation bar, click ","type":"text"},{"text":"Utilities ","type":"text","marks":[{"type":"strong"}]},{"text":">","type":"text"},{"text":" Manage Kyvos Repository","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the ","type":"text"},{"text":"Manage Kyvos","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Repository ","type":"text","marks":[{"type":"strong"}]},{"text":"page, select the ","type":"text"},{"text":"Bundled Postgres Repository","type":"text","marks":[{"type":"strong"}]},{"text":" option (by default, Bundled Postgres will be shown selected).","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":600,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":947,"id":"76bdb2fd-3d01-4798-b342-505ab21d1db2","collection":"contentId-380416674","type":"file","height":961},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select that cluster node from the dropdown on which the data dump is imported in step #2 above.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If needed, select the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}}]},{"text":"Restore Database Dump","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}},{"type":"strong"}]},{"text":" option to restore a dump of the Postgres database.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Locate Dump data","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}},{"type":"strong"}]},{"text":" from:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restore data from last backup","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}},{"type":"strong"}]},{"text":":","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}},{"type":"strong"}]},{"text":"Select this option to get the data restored from the last created backup.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Upload data dump file: ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}},{"type":"strong"}]},{"text":"Select this option to upload a previously saved data dump file.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0a0a0a"}}]}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Perform repository connection validation using ","type":"text"},{"text":"Test Connection","type":"text","marks":[{"type":"strong"}]},{"text":" link.","type":"text"},{"type":"hardBreak"},{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" In case of any problem with the test connection, you will see an error message. Fix those problems before proceeding with switching the repository.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Once the connection is validated successfully, click the ","type":"text"},{"text":"Save ","type":"text","marks":[{"type":"strong"}]},{"text":"button. This will configure new Postgres as a repository for Kyvos.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart the BI Server service.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Switching from bundled repository to external repository","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"bundtoexternal"},"legacyAnchorId":{"value":"SwitchingKyvosRepository-bundtoexternal"}},"macroMetadata":{"macroId":{"value":"cf5d36aacf5fb1145b83cd6deeabca713c5abc9d00bd8d62b84a28e8b11379ba"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"882118ae-7f4c-470a-928b-23d216f4c18e"}},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"In the case of a cloud environment, you can switch to an external repository. ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Export data from bundled Postgres.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Import the data exported from step #1 above, in the new Postgres instance (AWS RDS or Azure Postgres) running on the cloud.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the Kyvos Manager, navigate to ","type":"text"},{"text":"Utilities ","type":"text","marks":[{"type":"strong"}]},{"text":">","type":"text"},{"text":" Manage Kyvos Repository","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the page, select the ","type":"text"},{"text":"External Repository","type":"text","marks":[{"type":"strong"}]},{"text":" option (by default, the Bundled Postgres-Server is selected) ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter details as: ","type":"text"}]}]}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab-collection","parameters":{"macroParams":{"params":{"value":"JTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyM2NjY2VjZiUyMiU3RCU3RCU3RCU3RA=="}},"macroMetadata":{"macroId":{"value":"9ce637cb-d5b3-47f7-b7c5-5b02019c08e0"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab Group"}},"localId":"3aeff483-be9a-46bd-a1c7-bc369e21d55d"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab","parameters":{"macroParams":{"summary":{"value":"AWS "},"params":{"value":"JTdCJTIydGl0bGUlMjIlM0ElMjJBV1MlMjAlMjIlN0Q="}},"macroMetadata":{"macroId":{"value":"682dcbe2-443a-4445-80da-84bc0d02c4cf"},"schemaVersion":{"value":"1"},"indexedMacroParams":{"text":"AWS ","type":"text"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab (Must be used in Aura - Tab Group)"}},"localId":"cbf0cc53-6098-4252-ae97-71f2d8369409"}},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The IAM permissions must be required to fetch repository details. ","type":"text"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the","type":"text"},{"text":" Repository Identifier","type":"text","marks":[{"type":"strong"}]},{"text":", e.g. kyvosmanager-repo-database-ms24apr. ","type":"text"},{"type":"hardBreak"},{"text":"Note that the DB Identifier is the same as the Repository Identifier. Copy the ","type":"text"},{"text":"DB Identifier","type":"text","marks":[{"type":"strong"}]},{"text":" value and paste it in the ","type":"text"},{"text":" Repository Identifier","type":"text","marks":[{"type":"strong"}]},{"text":" section. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":700,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":765,"alt":"image-20240603-115635.png","id":"5c607aad-3ec0-4c6a-a426-ae14c047e819","collection":"contentId-380416674","type":"file","height":245},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Click ","type":"text"},{"text":"Fetch Details","type":"text","marks":[{"type":"strong"}]},{"text":". The information for ","type":"text"},{"text":"RDS Endpoint","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Port","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"Version","type":"text","marks":[{"type":"strong"}]},{"text":" is autopopulated by default for the target external repository.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":570,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":570,"alt":"image-20240603-120528.png","id":"be762e80-c5bc-48cc-aaab-64f1cd810284","collection":"contentId-380416674","type":"file","height":535},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab","parameters":{"macroParams":{"summary":{"value":"Azure"},"params":{"value":"JTdCJTIydGl0bGUlMjIlM0ElMjJBenVyZSUyMiU3RA=="}},"macroMetadata":{"macroId":{"value":"ad3e9b15-cbe5-42e3-8169-6b529921522a"},"schemaVersion":{"value":"1"},"indexedMacroParams":{"text":"Azure","type":"text"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab (Must be used in Aura - Tab Group)"}},"localId":"5501af68-77d8-44ab-865a-b9ed0fcd7aa8"}},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"No additional permission is required to fetch details unless the repository is in the same resource group as the Kyvos Manager machine. It is recommended that the repo should be kept in the same region.","type":"text"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the","type":"text"},{"text":" Server Name","type":"text","marks":[{"type":"strong"}]},{"text":", e.g. kyvos-postgresserver-85930","type":"text"},{"type":"hardBreak"},{"text":"Note that the Azure Database name is the same as the Server name. Copy the ","type":"text"},{"text":"Azure Database name","type":"text","marks":[{"type":"strong"}]},{"text":" value and paste it in the ","type":"text"},{"text":"Server name ","type":"text","marks":[{"type":"strong"}]},{"text":"field. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":754,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1164,"alt":"image-20240603-121456.png","id":"7e33e797-e5d3-4214-b9c7-32337143d9ad","collection":"contentId-380416674","type":"file","height":483},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Click ","type":"text"},{"text":"Fetch Details","type":"text","marks":[{"type":"strong"}]},{"text":". The information for ","type":"text"},{"text":"Database Node","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Port","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"Version","type":"text","marks":[{"type":"strong"}]},{"text":" is auto-populated by default for the target external repository.","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":600,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":569,"alt":"image-20240603-132440.png","id":"fb8ba5c3-9f35-4465-bf30-8e4245b99fc1","collection":"contentId-380416674","type":"file","height":537},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab","parameters":{"macroParams":{"summary":{"value":"GCP"},"params":{"value":"JTdCJTIydGl0bGUlMjIlM0ElMjJHQ1AlMjIlN0Q="}},"macroMetadata":{"macroId":{"value":"2e8fcef3-b92e-4e26-97b6-47b76ea2a1c4"},"schemaVersion":{"value":"1"},"indexedMacroParams":{"text":"GCP","type":"text"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab (Must be used in Aura - Tab Group)"}},"localId":"599a61b1-5789-42fe-bda9-e4e80f3c5a89"}},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the Server name. e.g. kyvos-postgresserver-22299","type":"text"},{"type":"hardBreak"},{"text":"Note that the SQL Instance Type is the same as the Server name. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Login to GCP Console. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Search for SQL Instance. In the ","type":"text"},{"text":"Instances","type":"text","marks":[{"type":"strong"}]},{"text":" section, copy the instance ","type":"text"},{"text":"Type","type":"text","marks":[{"type":"strong"}]},{"text":" as Postgres. The supported version of Postgres is13. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":700,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1111,"alt":"CloudSQL.png","id":"25df3160-df21-4405-92db-65d8044f9800","collection":"contentId-380416674","type":"file","height":562},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Click ","type":"text"},{"text":"Fetch Details","type":"text","marks":[{"type":"strong"}]},{"text":". The information for ","type":"text"},{"text":"Database Node","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Port","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"Version","type":"text","marks":[{"type":"strong"}]},{"text":" is auto-populated by default for the target external repository.","type":"text"},{"type":"hardBreak"},{"text":"NOTE","type":"text","marks":[{"type":"strong"}]},{"text":": The automatic start or stop of external repository is not supported.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":600,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":707,"alt":"image-20250218-074307.png","id":"15e7d413-13bb-424b-a51e-5ce2ed1429cb","collection":"contentId-380416674","type":"file","height":725},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]}]}]},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ensure that the Role attached on the Kyvos Manager node has sufficient permission to get External repository details.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In case fetch for details of the external repository fails, then manually provide the necessary details of the external repository (endpoint and port).","type":"text"}]}]}]}]},{"type":"orderedList","attrs":{"order":7},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the ","type":"text"},{"text":"Automatically Start or Stop ","type":"text","marks":[{"type":"strong"}]},{"text":"checkbox. ","type":"text"}]}]}]},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"Select this checkbox when your repository is not shared (only Kyvos is using this repository). If your repository is shared and it is being used by any other service, you must not select this checkbox. ","type":"text"}]}]},{"type":"orderedList","attrs":{"order":8},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Perform repository connection validation using ","type":"text"},{"text":"Test Connection","type":"text","marks":[{"type":"strong"}]},{"text":" link.","type":"text"},{"type":"hardBreak"},{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" In case of any problem with the test connection, you will see an error message. Fix those problems before proceeding with switching the repository.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Once the connection is validated successfully, click the ","type":"text"},{"text":"Save ","type":"text","marks":[{"type":"strong"}]},{"text":"button. This will configure new Postgres as a repository for Kyvos.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart the BI Server service.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":" Switching from external repository to another external repository ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"KyvosMigration"},"legacyAnchorId":{"value":"SwitchingKyvosRepository-KyvosMigration"}},"macroMetadata":{"macroId":{"value":"d820cb98fd7ad3d0b1bbd9fd36d2b82891d2231d0aa58e5a1bf07262d14a5e8d"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"59463cfc-02dc-4ad1-9dee-f43476ddb497"}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Export data from the current configured external Postgres repository (AWS RDS or Azure Postgres) running on the cloud.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Import the data exported in above step-1 to the new target external Postgres instance (AWS RDS or Azure Postgres) running on the cloud.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the Kyvos Manager, navigate to ","type":"text"},{"text":"Utilities > Manage Kyvos Repository","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the ","type":"text"},{"text":"Manage Repository ","type":"text","marks":[{"type":"strong"}]},{"text":"page, provide the details of the external repository you use. ","type":"text"}]}]}]},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ensure that the Role attached on the Kyvos Manager node has sufficient permission to get External repository details.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In case fetch for details of the external repository fails, then manually provide the necessary details of the external repository (endpoint and port).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Port access must be permitted as a prerequisite in the network security group.","type":"text"}]}]}]}]},{"type":"orderedList","attrs":{"order":5},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter details as: ","type":"text"}]}]}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab-collection","parameters":{"macroParams":{"params":{"value":"JTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyM2NjY2VjZiUyMiU3RCU3RCU3RCU3RA=="}},"macroMetadata":{"macroId":{"value":"3ad52aaa-6f62-4584-9d18-69e4234fa0b5"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab Group"}},"localId":"faaecfa7-3088-48b4-b44f-e056eb23c586"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab","parameters":{"macroParams":{"summary":{"value":"AWS "},"params":{"value":"JTdCJTIydGl0bGUlMjIlM0ElMjJBV1MlMjAlMjIlN0Q="}},"macroMetadata":{"macroId":{"value":"509f4149-f51d-4300-b387-fd3680574fad"},"schemaVersion":{"value":"1"},"indexedMacroParams":{"text":"AWS ","type":"text"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab (Must be used in Aura - Tab Group)"}},"localId":"a63edf0f-603e-4e25-bce4-c261c2d08584"}},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"The IAM permissions must be required to fetch repository details. ","type":"text"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the","type":"text"},{"text":" Repository Identifier","type":"text","marks":[{"type":"strong"}]},{"text":", e.g. kyvosmanager-repo-database-ms24apr. ","type":"text"},{"type":"hardBreak"},{"text":"Note that the DB Identifier is the same as the Repository Identifier. Copy the ","type":"text"},{"text":"DB Identifier","type":"text","marks":[{"type":"strong"}]},{"text":" value and paste it in the ","type":"text"},{"text":" Repository Identifier","type":"text","marks":[{"type":"strong"}]},{"text":" section. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":700,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":765,"alt":"image-20240603-115635.png","id":"5c607aad-3ec0-4c6a-a426-ae14c047e819","collection":"contentId-380416674","type":"file","height":245},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Click ","type":"text"},{"text":"Fetch Details","type":"text","marks":[{"type":"strong"}]},{"text":". The information for ","type":"text"},{"text":"RDS Endpoint","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Port","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"Version","type":"text","marks":[{"type":"strong"}]},{"text":" is autopopulated by default for the target external repository.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":570,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":570,"alt":"image-20240603-120528.png","id":"be762e80-c5bc-48cc-aaab-64f1cd810284","collection":"contentId-380416674","type":"file","height":535},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab","parameters":{"macroParams":{"summary":{"value":"Azure"},"params":{"value":"JTdCJTIydGl0bGUlMjIlM0ElMjJBenVyZSUyMiU3RA=="}},"macroMetadata":{"macroId":{"value":"d9a4921b-3cd2-4fff-bd93-0c3c03a5c783"},"schemaVersion":{"value":"1"},"indexedMacroParams":{"text":"Azure","type":"text"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab (Must be used in Aura - Tab Group)"}},"localId":"65238147-0a75-49b9-89b5-ae9224a8bf63"}},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"No additional permission is required to fetch details unless the repository is in the same resource group as the Kyvos Manager machine. It is recommended that the repo should be kept in the same region.","type":"text"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the","type":"text"},{"text":" Server Name","type":"text","marks":[{"type":"strong"}]},{"text":", e.g. kyvos-postgresserver-85930","type":"text"},{"type":"hardBreak"},{"text":"Note that the Azure Database name is the same as the Server name. Copy the ","type":"text"},{"text":"Azure Database name","type":"text","marks":[{"type":"strong"}]},{"text":" value and paste it in the ","type":"text"},{"text":"Server name ","type":"text","marks":[{"type":"strong"}]},{"text":"field. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":754,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1164,"alt":"image-20240603-121456.png","id":"7e33e797-e5d3-4214-b9c7-32337143d9ad","collection":"contentId-380416674","type":"file","height":483},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Click ","type":"text"},{"text":"Fetch Details","type":"text","marks":[{"type":"strong"}]},{"text":". The information for ","type":"text"},{"text":"Database Node","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Port","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"Version","type":"text","marks":[{"type":"strong"}]},{"text":" is auto-populated by default for the target external repository.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":569,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":569,"alt":"image-20240603-132506.png","id":"64a4d10d-dd6f-42b1-8b7d-918fcae317c5","collection":"contentId-380416674","type":"file","height":537},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]}]},{"type":"paragraph"},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"aura-tab","parameters":{"macroParams":{"summary":{"value":"GCP"},"params":{"value":"JTdCJTIydGl0bGUlMjIlM0ElMjJHQ1AlMjIlN0Q="}},"macroMetadata":{"macroId":{"value":"6ea4bccd-8de4-4e8e-9301-a4be7ab1726c"},"schemaVersion":{"value":"1"},"indexedMacroParams":{"text":"GCP","type":"text"},"placeholder":[{"type":"icon","data":{"url":"https://aura.cloudanvil.net/images/aura-macro-icon.png"}}],"title":"Aura - Tab (Must be used in Aura - Tab Group)"}},"localId":"6e855978-fbaa-465a-b42b-7b17dff55460"}},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the Server name. e.g. kyvos-postgresserver-22299","type":"text"},{"type":"hardBreak"},{"text":"Note that the SQL Instance Type is the same as the Server name. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Login to GCP Console. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Search for SQL Instance. In the ","type":"text"},{"text":"Instances","type":"text","marks":[{"type":"strong"}]},{"text":" section, copy the instance ","type":"text"},{"text":"Type","type":"text","marks":[{"type":"strong"}]},{"text":" as Postgres. The supported version of Postgres is13. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":700,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1111,"alt":"CloudSQL.png","id":"25df3160-df21-4405-92db-65d8044f9800","collection":"contentId-380416674","type":"file","height":562},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Click ","type":"text"},{"text":"Fetch Details","type":"text","marks":[{"type":"strong"}]},{"text":". The information for ","type":"text"},{"text":"Database Node","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Port","type":"text","marks":[{"type":"strong"}]},{"text":", and ","type":"text"},{"text":"Version","type":"text","marks":[{"type":"strong"}]},{"text":" is auto-populated by default for the target external repository.","type":"text"},{"type":"hardBreak"},{"text":"NOTE","type":"text","marks":[{"type":"strong"}]},{"text":": The automatic start or stop of repository is not supported.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":600,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":707,"alt":"image-20250218-074307.png","id":"15e7d413-13bb-424b-a51e-5ce2ed1429cb","collection":"contentId-380416674","type":"file","height":725},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]}]}]}]},{"type":"orderedList","attrs":{"order":6},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Perform repository connection validation using ","type":"text"},{"text":"Test Connection","type":"text","marks":[{"type":"strong"}]},{"text":" link.","type":"text"},{"type":"hardBreak"},{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" In case of any problem with the test connection, you will see an error message. Fix those problems before proceeding with switching the repository.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Once the connection is validated successfully, click the ","type":"text"},{"text":"Save ","type":"text","marks":[{"type":"strong"}]},{"text":"button. This will configure a new Postgres as a repository for Kyvos. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart the BI Server service.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Switching to a new bundled repository (recovered state) from the bundled repository ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"newbundledtonew"},"legacyAnchorId":{"value":"SwitchingKyvosRepository-newbundledtonew"}},"macroMetadata":{"macroId":{"value":"b0fe55a21536601c8a0ce4b731920fae2c7b7b5be3028d812a57c84d740cee4f"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"aebdc45a-baea-4635-9a6c-e32337e27c35"}}]},{"type":"paragraph","content":[{"text":" The following procedure is required in Kyvos Manager node Disaster Recovery case. When the bundled Postgres was configured on Kyvos Manager node. ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Download data dump from DFS.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In an existing cluster, identify the target node for running bundled Postgres and start the Postgres service on that target node, and import that data into that Postgres instance which was downloaded as a dump from DFS in step #1.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the Kyvos Manager, navigate to ","type":"text"},{"text":"Utilities > Manage Kyvos Repository","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the ","type":"text"},{"text":"Manage Repository ","type":"text","marks":[{"type":"strong"}]},{"text":"page, select the ","type":"text"},{"text":"Bundled Postgres Repository","type":"text","marks":[{"type":"strong"}]},{"text":" option (by default external repository will be shown selected).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Provide details for the target ","type":"text"},{"text":"External","type":"text","marks":[{"type":"strong"}]},{"text":" repository.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Perform repository connection validation using ","type":"text"},{"text":"Test Connection","type":"text","marks":[{"type":"strong"}]},{"text":" link.","type":"text"},{"type":"hardBreak"},{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" In case of any problem with the test connection, you will see an error message. Fix those problems before proceeding with switching the repository.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Once the connection is validated successfully, click the ","type":"text"},{"text":"Save ","type":"text","marks":[{"type":"strong"}]},{"text":"button. This will configure new Postgres as a repository for Kyvos.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Restart the BI Server service.","type":"text"}]}]}]}],"version":1}