Versions Compared

Old Version 1

changes.mady.by.user NIDHI BHANDARI

Saved on

compared with

New Version 2

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to: (tick) Kyvos Enterprise  (tick) Kyvos Cloud (SaaS on AWS) (error) Kyvos AWS Marketplace

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

From Kyvos 2023.3 onwards, you can see the last operation details, including progress status and start time, by clicking the i icon. To view more comprehensive details, simply click the View Details link, which will take you to the Operations page, where you can view the operation information in detail. 

Switching from an external repository to bundled repository

  1. Export data from external Postgres (AWS RDS or Azure Postgres).

  2. In an existing cluster, identify the target node for running bundled Postgres and start the Postgres service on that target node.

  3. On the navigation bar, click Utilities > Manage Kyvos Repository.

  4. On the Manage Kyvos Repository page, select the Bundled Postgres Repository option (by default, bundled Postgres will be shown selected).

  5. Select that cluster node from the dropdown on which the data dump is imported in step #2 above.

  6. If needed, select the Restore Database Dump option to restore a dump of the Postgres database.

    1. Locate Dump data from:

      1. Restore data from last backup:Select this option to get the data restored from the last created backup.

      2. Upload data dump file: Select this option to upload a previously saved data dump file.

  7. Perform repository connection validation using Test Connection link.
    NOTE: In case of any problem with the test connection, you will see an error message. Fix those problems before proceeding with switching the repository.

  8. Once the connection is validated successfully, click the Save button. This will configure new Postgres as a repository for Kyvos.

  9. Restart the BI Server service.

...

Code Block
(drop database delverepo; create database delverepo;)
./psql -U {USER-NAME} -p {PORT} -d delverepo < {PATH-TO-FILE-IN-WHICH-CONTAINS-EXPORTED-DUMP}

Commands to connect with Flexible Server

Code Block
./pgconnect.sh 5432 username servername database
./pgconnect.sh 5432 postgres kyvos-postgresserver-9900.postgres.database.azure.com delverepo

Import command for Flexible Server

Code Block
./psql -U ${user} -h ${hostname} -f ${filename}
./psql -U postgres -h kyvos-postgresserver-63058.postgres.database.azure.com -f databasedump

Export command for Flexible Server

Code Block
./pg_dump -c -C --host=<host> --port=<port> --dbname=<database name> --user=<user name> --password=<password> <file name>
 ./pg_dump -c -C "host=kyvos-postgresserver-1010.postgres.database.azure.com port=5432 dbname=delverepo user=postgres@kyvos-postgresserver-1010 password=delve@123" > Kyvos2023-5-Build026-014-D2023-Nov-14-T12-46-41