Aura tab |
---|
summary | Azure Postgres backup |
---|
params | JTdCJTIydGl0bGUlMjIlM0ElMjJBenVyZSUyMFBvc3RncmVzJTIwYmFja3VwJTIwJTIyJTdE |
---|
|
Before upgrading the Kyvos version in cluster, you must export the Azure Postgres dump. NOTE: This must be done when the BI Server is in stop state. Execute the following command: ./pg_dump -c -C --host=<host> --port=<port> --dbname=<database name> --user=<user name> --password=<password> <database>.sql For example, ./pg_dump -c -C "host=kyvos-postgresserver-1010.postgres.database.azure.com port=5432 dbname=delverepo user=postgres@kyvos-postgresserver-1010 password=delve@123" > data-dump.sq Save the Azure Postgres dump otherwise the rollback to this state will not be possible. In case you face an error, such as: “./pg_dump: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory”, then execute the LD_LIBRARY_PATH command, for example: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/kyvos/app/kyvos/postgres/lib When upgrading, if the database backup has already been taken, a dialog will appear on the Upgrade screen prompting you to select the following checkboxes. After selecting the appropriate checkboxes, enter your Kyvos Manager password. See the Upgrading Kyvos section for more details. Click Upgrade.
Aura tab |
---|
summary | Azure Postgres restore |
---|
params | JTdCJTIydGl0bGUlMjIlM0ElMjJBenVyZSUyMFBvc3RncmVzJTIwcmVzdG9yZSUyMiU3RA== |
---|
|
Create Azure Postgres SQL Database. Take the restored DelveRepo backup (created before upgrade) and restore it in the newly created PostgreSQL database (created in step 1). To do this, do one of the following: Execute the following command: kyvos/postgres/bin/pg_restore -c -C "host=localhost port=45421 dbname=delverepo user=postgres password=PROVIDE-ACTUAL_PWD" > data_backup.sql For example, ./pg_restore -c -C "host=kyvos-postgresserver-1010.postgres.database.azure.com port=5432 dbname=delverepo user=postgres@kyvos-postgresserver-1010 password=delve@123" delverepo_backup.sql -or- Click Go to Manage Kyvos Repository. You will be redirected to the Manage Kyvos Repository page. Provide the details for newly created repository in which dump is imported, and then click Fetch details. Before saving, click Test connection, and then click Save.
|