search

IBM / ibm-common-service-operator

Operator to install IBM Common Services
https://www.ibm.com/support/knowledgecenter/SSHKN6/kc_welcome_cs.html
Apache License 2.0
19 stars 68 forks source link

MCSP BR #2082

Closed qpdpQ closed 4 weeks ago

qpdpQ commented 3 months ago

add mcsp database to cs-db br configmap

qpdpQ commented 3 months ago
backup test sh-4.4$ ./cs-db/br_cs-db.sh backup test
``` [INFO] Mode set to backup, beginning backup process. [INFO] Beginning backup of cloudpak database... pg_dump: last built-in OID is 16383 pg_dump: reading extensions pg_dump: identifying extension members pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined access methods pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading transforms pg_dump: reading table inheritance information pg_dump: reading event triggers pg_dump: finding extension tables pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: flagging inherited columns in subtables pg_dump: reading partitioning data pg_dump: reading indexes pg_dump: flagging indexes in partitioned tables pg_dump: reading extended statistics pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading rewrite rules pg_dump: reading policies pg_dump: reading row-level security policies pg_dump: reading publications pg_dump: reading publication membership of tables pg_dump: reading publication membership of schemas pg_dump: reading subscriptions pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving search_path = pg_dump: saving database definition [INFO] Beginning backup of im database... pg_dump: last built-in OID is 16383 pg_dump: reading extensions pg_dump: identifying extension members pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined access methods pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading transforms pg_dump: reading table inheritance information pg_dump: reading event triggers pg_dump: finding extension tables pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: finding table default expressions pg_dump: flagging inherited columns in subtables pg_dump: reading partitioning data pg_dump: reading indexes pg_dump: flagging indexes in partitioned tables pg_dump: reading extended statistics pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading rewrite rules pg_dump: reading policies pg_dump: reading row-level security policies pg_dump: reading publications pg_dump: reading publication membership of tables pg_dump: reading publication membership of schemas pg_dump: reading subscriptions pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving search_path = pg_dump: saving database definition pg_dump: dumping contents of table "oauthdbschema.oauthclient" pg_dump: dumping contents of table "oauthdbschema.oauthconsent" pg_dump: dumping contents of table "oauthdbschema.oauthtoken" pg_dump: dumping contents of table "platformdb.apikeys" pg_dump: dumping contents of table "platformdb.groups" pg_dump: dumping contents of table "platformdb.idp_configs" pg_dump: dumping contents of table "platformdb.rolemappings" pg_dump: dumping contents of table "platformdb.scim_attributes" pg_dump: dumping contents of table "platformdb.scim_attributes_mappings" pg_dump: dumping contents of table "platformdb.scim_server_groups" pg_dump: dumping contents of table "platformdb.scim_server_groups_custom" pg_dump: dumping contents of table "platformdb.scim_server_users" pg_dump: dumping contents of table "platformdb.scim_server_users_custom" pg_dump: dumping contents of table "platformdb.users" pg_dump: dumping contents of table "platformdb.users_attributes" pg_dump: dumping contents of table "platformdb.users_groups" pg_dump: dumping contents of table "platformdb.users_preferences" pg_dump: dumping contents of table "platformdb.zen_instances" pg_dump: dumping contents of table "platformdb.zen_instances_users" [INFO] Beginning backup of zen database... pg_dump: last built-in OID is 16383 pg_dump: reading extensions pg_dump: identifying extension members pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined access methods pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading transforms pg_dump: reading table inheritance information pg_dump: reading event triggers pg_dump: finding extension tables pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: flagging inherited columns in subtables pg_dump: reading partitioning data pg_dump: reading indexes pg_dump: flagging indexes in partitioned tables pg_dump: reading extended statistics pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading rewrite rules pg_dump: reading policies pg_dump: reading row-level security policies pg_dump: reading publications pg_dump: reading publication membership of tables pg_dump: reading publication membership of schemas pg_dump: reading subscriptions pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving search_path = pg_dump: saving database definition [INFO] Beginning backup of account_iam database... pg_dump: last built-in OID is 16383 pg_dump: reading extensions pg_dump: identifying extension members pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined access methods pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading transforms pg_dump: reading table inheritance information pg_dump: reading event triggers pg_dump: finding extension tables pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: finding table default expressions pg_dump: finding table check constraints pg_dump: flagging inherited columns in subtables pg_dump: reading partitioning data pg_dump: reading indexes pg_dump: flagging indexes in partitioned tables pg_dump: reading extended statistics pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading rewrite rules pg_dump: reading policies pg_dump: reading row-level security policies pg_dump: reading publications pg_dump: reading publication membership of tables pg_dump: reading publication membership of schemas pg_dump: reading subscriptions pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving search_path = pg_dump: saving database definition pg_dump: dumping contents of table "accountiam.apikey" pg_dump: dumping contents of table "accountiam.author" pg_dump: dumping contents of table "accountiam.flyway_schema_history" pg_dump: dumping contents of table "accountiam.group_binding" pg_dump: dumping contents of table "accountiam.idp_config" pg_dump: dumping contents of table "accountiam.igroup" pg_dump: dumping contents of table "accountiam.invited_serviceid" pg_dump: dumping contents of table "accountiam.invited_user" pg_dump: dumping contents of table "accountiam.iuser" pg_dump: dumping contents of table "accountiam.role" pg_dump: dumping contents of table "accountiam.role_binding" pg_dump: dumping contents of table "accountiam.scope" pg_dump: dumping contents of table "accountiam.serviceid" [INFO] Copy backup file. Defaulted container "postgres" out of: postgres, bootstrap-controller (init) tar: Removing leading `/' from member names Defaulted container "postgres" out of: postgres, bootstrap-controller (init) tar: Removing leading `/' from member names Defaulted container "postgres" out of: postgres, bootstrap-controller (init) tar: Removing leading `/' from member names Defaulted container "postgres" out of: postgres, bootstrap-controller (init) tar: Removing leading `/' from member names [✔] Backup completed successfully. ```
qpdpQ commented 3 months ago
restore test
``` sh-4.4$ ./cs-db/br_cs-db.sh restore test [INFO] Mode is set to restore, beginning restore process. [INFO] Waiting for EDB Cluster CR common-service-db to complete in namespace test. [INFO] EDB cluster common-service-db ready. Defaulted container "postgres" out of: postgres, bootstrap-controller (init) Defaulted container "postgres" out of: postgres, bootstrap-controller (init) Defaulted container "postgres" out of: postgres, bootstrap-controller (init) Defaulted container "postgres" out of: postgres, bootstrap-controller (init) Defaulted container "postgres" out of: postgres, bootstrap-controller (init) List of databases Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges -------------+----------+----------+-----------------+---------+-------+------------+-----------+----------------------------- account_iam | postgres | UTF8 | libc | C | C | | | postgres=CTc/postgres + | | | | | | | | user_accountiam=Tc/postgres cloudpak | cpadmin | UTF8 | libc | C | C | | | im | im_user | UTF8 | libc | C | C | | | =Tc/im_user + | | | | | | | | im_user=CTc/im_user postgres | postgres | UTF8 | libc | C | C | | | template0 | postgres | UTF8 | libc | C | C | | | =c/postgres + | | | | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | libc | C | C | | | =c/postgres + | | | | | | | | postgres=CTc/postgres zen | zen_user | UTF8 | libc | C | C | | | =Tc/zen_user + | | | | | | | | zen_user=CTc/zen_user (7 rows) List of schemas Name | Owner --------+------------------- public | pg_database_owner (1 row) List of roles Role name | Attributes -------------------+------------------------------------------------------------ cpadmin | im_user | postgres | Superuser, Create role, Create DB, Replication, Bypass RLS streaming_replica | Replication user_accountiam | zen_user | [INFO] Beginning restore of cloudpak database... pg_restore: connecting to database for restore pg_restore: implied data-only restore [INFO] Beginning restore of im database... pg_restore: connecting to database for restore pg_restore: dropping FK CONSTRAINT users_groups users_groups_user_uid_fkey pg_restore: dropping FK CONSTRAINT users_groups users_groups_group_uid_fkey pg_restore: dropping FK CONSTRAINT scim_server_users_custom scim_server_users_custom_scim_server_user_uid_fkey pg_restore: dropping FK CONSTRAINT scim_server_groups_custom scim_server_groups_custom_scim_server_group_uid_fkey pg_restore: dropping FK CONSTRAINT zen_instances_users fk_zenuser_fk pg_restore: dropping FK CONSTRAINT zen_instances_users fk_userzen_fk pg_restore: dropping FK CONSTRAINT users_preferences fk_userpref_fk pg_restore: dropping FK CONSTRAINT users_attributes fk_useratt_fk pg_restore: dropping INDEX oauth20cache_expires pg_restore: dropping CONSTRAINT zen_instances_users zeninstances_users_uid pg_restore: dropping CONSTRAINT zen_instances zen_instances_instance_id pg_restore: dropping CONSTRAINT users users_userid pg_restore: dropping CONSTRAINT users users_uid pg_restore: dropping CONSTRAINT users_preferences users_preferences_useruid pg_restore: dropping CONSTRAINT users_preferences users_preferences_uid pg_restore: dropping CONSTRAINT users_groups users_groups_pkey pg_restore: dropping CONSTRAINT users_attributes users_attributes_uid pg_restore: dropping CONSTRAINT scim_server_users scim_server_users_pkey pg_restore: dropping CONSTRAINT scim_server_users_custom scim_server_users_custom_pkey pg_restore: dropping CONSTRAINT scim_server_groups scim_server_groups_pkey pg_restore: dropping CONSTRAINT scim_server_groups_custom scim_server_groups_custom_pkey pg_restore: dropping CONSTRAINT scim_attributes scim_attributes_id pg_restore: dropping CONSTRAINT scim_attributes_mappings scim_attributemappings_idp_id pg_restore: dropping CONSTRAINT rolemappings rolemappings_pkey pg_restore: dropping CONSTRAINT idp_configs idp_configs_uid pg_restore: dropping CONSTRAINT groups groups_pkey pg_restore: dropping CONSTRAINT groups groups_group_id_realm_id pg_restore: dropping CONSTRAINT apikeys apikeys_pkey pg_restore: dropping CONSTRAINT oauthtoken pk_lookupkey pg_restore: dropping CONSTRAINT oauthclient pk_compidclientid pg_restore: dropping DEFAULT apikeys id pg_restore: dropping DEFAULT oauthtoken _id pg_restore: dropping DEFAULT oauthconsent _id pg_restore: dropping DEFAULT oauthclient _id pg_restore: dropping TABLE zen_instances_users pg_restore: dropping TABLE zen_instances pg_restore: dropping VIEW view_scim_server_users_custom pg_restore: dropping VIEW view_scim_server_groups_custom pg_restore: dropping TABLE users_preferences pg_restore: dropping TABLE users_groups pg_restore: dropping TABLE users_attributes pg_restore: dropping TABLE users pg_restore: dropping TABLE scim_server_users_custom pg_restore: dropping TABLE scim_server_users pg_restore: dropping TABLE scim_server_groups_custom pg_restore: dropping TABLE scim_server_groups pg_restore: dropping TABLE scim_attributes_mappings pg_restore: dropping TABLE scim_attributes pg_restore: dropping TABLE rolemappings pg_restore: dropping TABLE idp_configs pg_restore: dropping TABLE groups pg_restore: dropping SEQUENCE apikeys_id_seq pg_restore: dropping TABLE apikeys pg_restore: dropping SEQUENCE oauthtoken__id_seq pg_restore: dropping TABLE oauthtoken pg_restore: dropping SEQUENCE oauthconsent__id_seq pg_restore: dropping TABLE oauthconsent pg_restore: dropping SEQUENCE oauthclient__id_seq pg_restore: dropping TABLE oauthclient pg_restore: dropping SCHEMA platformdb pg_restore: dropping SCHEMA oauthdbschema pg_restore: creating SCHEMA "oauthdbschema" pg_restore: creating SCHEMA "platformdb" pg_restore: creating TABLE "oauthdbschema.oauthclient" pg_restore: creating SEQUENCE "oauthdbschema.oauthclient__id_seq" pg_restore: creating SEQUENCE OWNED BY "oauthdbschema.oauthclient__id_seq" pg_restore: creating TABLE "oauthdbschema.oauthconsent" pg_restore: creating SEQUENCE "oauthdbschema.oauthconsent__id_seq" pg_restore: creating SEQUENCE OWNED BY "oauthdbschema.oauthconsent__id_seq" pg_restore: creating TABLE "oauthdbschema.oauthtoken" pg_restore: creating SEQUENCE "oauthdbschema.oauthtoken__id_seq" pg_restore: creating SEQUENCE OWNED BY "oauthdbschema.oauthtoken__id_seq" pg_restore: creating TABLE "platformdb.apikeys" pg_restore: creating SEQUENCE "platformdb.apikeys_id_seq" pg_restore: creating SEQUENCE OWNED BY "platformdb.apikeys_id_seq" pg_restore: creating TABLE "platformdb.groups" pg_restore: creating TABLE "platformdb.idp_configs" pg_restore: creating TABLE "platformdb.rolemappings" pg_restore: creating TABLE "platformdb.scim_attributes" pg_restore: creating TABLE "platformdb.scim_attributes_mappings" pg_restore: creating TABLE "platformdb.scim_server_groups" pg_restore: creating TABLE "platformdb.scim_server_groups_custom" pg_restore: creating TABLE "platformdb.scim_server_users" pg_restore: creating TABLE "platformdb.scim_server_users_custom" pg_restore: creating TABLE "platformdb.users" pg_restore: creating TABLE "platformdb.users_attributes" pg_restore: creating TABLE "platformdb.users_groups" pg_restore: creating TABLE "platformdb.users_preferences" pg_restore: creating VIEW "platformdb.view_scim_server_groups_custom" pg_restore: creating VIEW "platformdb.view_scim_server_users_custom" pg_restore: creating TABLE "platformdb.zen_instances" pg_restore: creating TABLE "platformdb.zen_instances_users" pg_restore: creating DEFAULT "oauthdbschema.oauthclient _id" pg_restore: creating DEFAULT "oauthdbschema.oauthconsent _id" pg_restore: creating DEFAULT "oauthdbschema.oauthtoken _id" pg_restore: creating DEFAULT "platformdb.apikeys id" pg_restore: processing data for table "oauthdbschema.oauthclient" pg_restore: processing data for table "oauthdbschema.oauthconsent" pg_restore: processing data for table "oauthdbschema.oauthtoken" pg_restore: processing data for table "platformdb.apikeys" pg_restore: processing data for table "platformdb.groups" pg_restore: processing data for table "platformdb.idp_configs" pg_restore: processing data for table "platformdb.rolemappings" pg_restore: processing data for table "platformdb.scim_attributes" pg_restore: processing data for table "platformdb.scim_attributes_mappings" pg_restore: processing data for table "platformdb.scim_server_groups" pg_restore: processing data for table "platformdb.scim_server_groups_custom" pg_restore: processing data for table "platformdb.scim_server_users" pg_restore: processing data for table "platformdb.scim_server_users_custom" pg_restore: processing data for table "platformdb.users" pg_restore: processing data for table "platformdb.users_attributes" pg_restore: processing data for table "platformdb.users_groups" pg_restore: processing data for table "platformdb.users_preferences" pg_restore: processing data for table "platformdb.zen_instances" pg_restore: processing data for table "platformdb.zen_instances_users" pg_restore: executing SEQUENCE SET oauthclient__id_seq pg_restore: executing SEQUENCE SET oauthconsent__id_seq pg_restore: executing SEQUENCE SET oauthtoken__id_seq pg_restore: executing SEQUENCE SET apikeys_id_seq pg_restore: creating CONSTRAINT "oauthdbschema.oauthclient pk_compidclientid" pg_restore: creating CONSTRAINT "oauthdbschema.oauthtoken pk_lookupkey" pg_restore: creating CONSTRAINT "platformdb.apikeys apikeys_pkey" pg_restore: creating CONSTRAINT "platformdb.groups groups_group_id_realm_id" pg_restore: creating CONSTRAINT "platformdb.groups groups_pkey" pg_restore: creating CONSTRAINT "platformdb.idp_configs idp_configs_uid" pg_restore: creating CONSTRAINT "platformdb.rolemappings rolemappings_pkey" pg_restore: creating CONSTRAINT "platformdb.scim_attributes_mappings scim_attributemappings_idp_id" pg_restore: creating CONSTRAINT "platformdb.scim_attributes scim_attributes_id" pg_restore: creating CONSTRAINT "platformdb.scim_server_groups_custom scim_server_groups_custom_pkey" pg_restore: creating CONSTRAINT "platformdb.scim_server_groups scim_server_groups_pkey" pg_restore: creating CONSTRAINT "platformdb.scim_server_users_custom scim_server_users_custom_pkey" pg_restore: creating CONSTRAINT "platformdb.scim_server_users scim_server_users_pkey" pg_restore: creating CONSTRAINT "platformdb.users_attributes users_attributes_uid" pg_restore: creating CONSTRAINT "platformdb.users_groups users_groups_pkey" pg_restore: creating CONSTRAINT "platformdb.users_preferences users_preferences_uid" pg_restore: creating CONSTRAINT "platformdb.users_preferences users_preferences_useruid" pg_restore: creating CONSTRAINT "platformdb.users users_uid" pg_restore: creating CONSTRAINT "platformdb.users users_userid" pg_restore: creating CONSTRAINT "platformdb.zen_instances zen_instances_instance_id" pg_restore: creating CONSTRAINT "platformdb.zen_instances_users zeninstances_users_uid" pg_restore: creating INDEX "oauthdbschema.oauth20cache_expires" pg_restore: creating FK CONSTRAINT "platformdb.users_attributes fk_useratt_fk" pg_restore: creating FK CONSTRAINT "platformdb.users_preferences fk_userpref_fk" pg_restore: creating FK CONSTRAINT "platformdb.zen_instances_users fk_userzen_fk" pg_restore: creating FK CONSTRAINT "platformdb.zen_instances_users fk_zenuser_fk" pg_restore: creating FK CONSTRAINT "platformdb.scim_server_groups_custom scim_server_groups_custom_scim_server_group_uid_fkey" pg_restore: creating FK CONSTRAINT "platformdb.scim_server_users_custom scim_server_users_custom_scim_server_user_uid_fkey" pg_restore: creating FK CONSTRAINT "platformdb.users_groups users_groups_group_uid_fkey" pg_restore: creating FK CONSTRAINT "platformdb.users_groups users_groups_user_uid_fkey" [INFO] Beginning restore of zen database... pg_restore: connecting to database for restore pg_restore: implied data-only restore [INFO] Beginning restore of account_iam database... pg_restore: connecting to database for restore pg_restore: dropping FK CONSTRAINT iuser user_modified_by_fkey pg_restore: dropping FK CONSTRAINT iuser user_created_by_fkey pg_restore: dropping FK CONSTRAINT serviceid serviceid_scope_uid_fkey pg_restore: dropping FK CONSTRAINT serviceid serviceid_modified_by_fkey pg_restore: dropping FK CONSTRAINT serviceid serviceid_created_by_fkey pg_restore: dropping FK CONSTRAINT scope scope_product_scope_uid_index_fk pg_restore: dropping FK CONSTRAINT scope scope_parent_scope_uid_fkey pg_restore: dropping FK CONSTRAINT scope scope_modified_by_fkey pg_restore: dropping FK CONSTRAINT scope scope_created_by_fkey pg_restore: dropping FK CONSTRAINT role role_scope_uid_fkey pg_restore: dropping FK CONSTRAINT role role_modified_by_fkey pg_restore: dropping FK CONSTRAINT role role_created_by_fkey pg_restore: dropping FK CONSTRAINT role_binding role_binding_scope_uid_fkey pg_restore: dropping FK CONSTRAINT role_binding role_binding_role_uid_fkey pg_restore: dropping FK CONSTRAINT role_binding role_binding_modified_by_fkey pg_restore: dropping FK CONSTRAINT role_binding role_binding_member_user_uid_fkey pg_restore: dropping FK CONSTRAINT role_binding role_binding_member_serviceid_uid_fkey pg_restore: dropping FK CONSTRAINT role_binding role_binding_member_group_uid_fkey pg_restore: dropping FK CONSTRAINT role_binding role_binding_created_by_fkey pg_restore: dropping FK CONSTRAINT iuser iuser_scope_uid_fkey pg_restore: dropping FK CONSTRAINT iuser iuser_idp_config_uid_fkey pg_restore: dropping FK CONSTRAINT invited_user invited_user_user_uid_fkey pg_restore: dropping FK CONSTRAINT invited_user invited_user_scope_uid_fkey pg_restore: dropping FK CONSTRAINT invited_user invited_user_modified_by_fkey pg_restore: dropping FK CONSTRAINT invited_user invited_user_created_by_fkey pg_restore: dropping FK CONSTRAINT invited_serviceid invited_serviceid_serviceid_uid_fkey pg_restore: dropping FK CONSTRAINT invited_serviceid invited_serviceid_scope_uid_fkey pg_restore: dropping FK CONSTRAINT invited_serviceid invited_serviceid_modified_by_fkey pg_restore: dropping FK CONSTRAINT invited_serviceid invited_serviceid_created_by_fkey pg_restore: dropping FK CONSTRAINT igroup igroup_scope_uid_fkey pg_restore: dropping FK CONSTRAINT igroup igroup_modified_by_fkey pg_restore: dropping FK CONSTRAINT igroup igroup_created_by_fkey pg_restore: dropping FK CONSTRAINT idp_config idp_modified_by_fkey pg_restore: dropping FK CONSTRAINT idp_config idp_created_by_fkey pg_restore: dropping FK CONSTRAINT idp_config idp_config_scope_uid_fkey pg_restore: dropping FK CONSTRAINT group_binding group_binding_modified_by_fkey pg_restore: dropping FK CONSTRAINT group_binding group_binding_member_user_uid_fkey pg_restore: dropping FK CONSTRAINT group_binding group_binding_member_serviceid_uid_fkey pg_restore: dropping FK CONSTRAINT group_binding group_binding_group_uid_fkey pg_restore: dropping FK CONSTRAINT group_binding group_binding_created_by_fkey pg_restore: dropping FK CONSTRAINT author author_user_uid_fkey pg_restore: dropping FK CONSTRAINT author author_serviceid_uid_fkey pg_restore: dropping FK CONSTRAINT apikey apikey_user_uid_fkey pg_restore: dropping FK CONSTRAINT apikey apikey_serviceid_uid_fkey pg_restore: dropping FK CONSTRAINT apikey apikey_scope_uid_fkey pg_restore: dropping FK CONSTRAINT apikey apikey_modified_by_fkey pg_restore: dropping FK CONSTRAINT apikey apikey_created_by_fkey pg_restore: dropping INDEX serviceid_scope_uid_idx pg_restore: dropping INDEX serviceid_modified_by_idx pg_restore: dropping INDEX serviceid_created_by_idx pg_restore: dropping INDEX scope_product_scope_uid_idx pg_restore: dropping INDEX scope_parent_scope_uid_idx pg_restore: dropping INDEX role_scope_uid_idx pg_restore: dropping INDEX role_modified_by_idx pg_restore: dropping INDEX role_created_by_idx pg_restore: dropping INDEX role_binding_user_uid_idx pg_restore: dropping INDEX role_binding_serviceid_uid_idx pg_restore: dropping INDEX role_binding_scope_role_serviceid_idx pg_restore: dropping INDEX role_binding_scope_role_group_idx pg_restore: dropping INDEX role_binding_role_uid_idx pg_restore: dropping INDEX role_binding_modified_by_idx pg_restore: dropping INDEX role_binding_group_uid_idx pg_restore: dropping INDEX role_binding_created_by_idx pg_restore: dropping INDEX iuser_scope_uid_idx pg_restore: dropping INDEX iuser_modified_by_idx pg_restore: dropping INDEX iuser_idp_config_idx pg_restore: dropping INDEX iuser_created_by_idx pg_restore: dropping INDEX invited_user_scope_uid pg_restore: dropping INDEX invited_user_pool_user_uid pg_restore: dropping INDEX igroup_scope_uid_idx pg_restore: dropping INDEX igroup_modified_by_idx pg_restore: dropping INDEX igroup_created_by_idx pg_restore: dropping INDEX idp_scope_uid_idx pg_restore: dropping INDEX idp_modified_by_idx pg_restore: dropping INDEX idp_created_by_idx pg_restore: dropping INDEX group_binding_user_uid_idx pg_restore: dropping INDEX group_binding_serviceid_uid_idx pg_restore: dropping INDEX group_binding_modified_by_idx pg_restore: dropping INDEX group_binding_group_serviceid_uids_idx pg_restore: dropping INDEX group_binding_created_by_idx pg_restore: dropping INDEX flyway_schema_history_s_idx pg_restore: dropping INDEX author_user_uid_idx pg_restore: dropping INDEX author_serviceid_uid_idx pg_restore: dropping INDEX apikey_user_uid_idx pg_restore: dropping INDEX apikey_serviceid_uid_idx pg_restore: dropping INDEX apikey_scope_uid_idx pg_restore: dropping INDEX apikey_modified_by_idx pg_restore: dropping INDEX apikey_created_by_idx pg_restore: dropping CONSTRAINT serviceid serviceid_scope_uid_name_key pg_restore: dropping CONSTRAINT serviceid serviceid_pkey pg_restore: dropping CONSTRAINT scope scope_scope_type_scope_id_key pg_restore: dropping CONSTRAINT scope scope_pkey pg_restore: dropping CONSTRAINT role role_scope_uid_name_key pg_restore: dropping CONSTRAINT role role_pkey pg_restore: dropping CONSTRAINT role_binding role_binding_scope_uid_role_uid_member_user_uid_member_serv_key pg_restore: dropping CONSTRAINT role_binding role_binding_pkey pg_restore: dropping CONSTRAINT iuser iuser_scope_uid_idp_config_uid_idp_unique_id_key pg_restore: dropping CONSTRAINT iuser iuser_scope_uid_idp_config_uid_email_key pg_restore: dropping CONSTRAINT iuser iuser_pkey pg_restore: dropping CONSTRAINT invited_user invited_user_pkey pg_restore: dropping CONSTRAINT invited_serviceid invited_serviceid_pkey pg_restore: dropping CONSTRAINT igroup igroup_scope_uid_name_key pg_restore: dropping CONSTRAINT igroup igroup_pkey pg_restore: dropping CONSTRAINT idp_config idp_config_scope_uid_idp_realm_key pg_restore: dropping CONSTRAINT idp_config idp_config_pkey pg_restore: dropping CONSTRAINT group_binding group_binding_pkey pg_restore: dropping CONSTRAINT group_binding group_binding_group_uid_member_user_uid_member_serviceid_ui_key pg_restore: dropping CONSTRAINT flyway_schema_history flyway_schema_history_pk pg_restore: dropping CONSTRAINT author author_pkey pg_restore: dropping CONSTRAINT author author_author_type_user_uid_serviceid_uid_key pg_restore: dropping CONSTRAINT apikey apikey_user_uid_serviceid_uid_name_key pg_restore: dropping CONSTRAINT apikey apikey_pkey pg_restore: dropping TABLE serviceid pg_restore: dropping TABLE scope pg_restore: dropping TABLE role_binding pg_restore: dropping TABLE role pg_restore: dropping TABLE iuser pg_restore: dropping TABLE invited_user pg_restore: dropping TABLE invited_serviceid pg_restore: dropping TABLE igroup pg_restore: dropping TABLE idp_config pg_restore: dropping TABLE group_binding pg_restore: dropping TABLE flyway_schema_history pg_restore: dropping TABLE author pg_restore: dropping TABLE apikey pg_restore: dropping TYPE user_status_enum pg_restore: dropping TYPE serviceid_status_enum pg_restore: dropping TYPE scope_type_enum pg_restore: dropping TYPE scope_status_enum pg_restore: dropping TYPE group_status_enum pg_restore: dropping TYPE author_type_enum pg_restore: dropping SCHEMA accountiam pg_restore: creating SCHEMA "accountiam" pg_restore: creating TYPE "accountiam.author_type_enum" pg_restore: creating TYPE "accountiam.group_status_enum" pg_restore: creating TYPE "accountiam.scope_status_enum" pg_restore: creating TYPE "accountiam.scope_type_enum" pg_restore: creating TYPE "accountiam.serviceid_status_enum" pg_restore: creating TYPE "accountiam.user_status_enum" pg_restore: creating TABLE "accountiam.apikey" pg_restore: creating TABLE "accountiam.author" pg_restore: creating TABLE "accountiam.flyway_schema_history" pg_restore: creating TABLE "accountiam.group_binding" pg_restore: creating TABLE "accountiam.idp_config" pg_restore: creating TABLE "accountiam.igroup" pg_restore: creating TABLE "accountiam.invited_serviceid" pg_restore: creating TABLE "accountiam.invited_user" pg_restore: creating TABLE "accountiam.iuser" pg_restore: creating TABLE "accountiam.role" pg_restore: creating TABLE "accountiam.role_binding" pg_restore: creating TABLE "accountiam.scope" pg_restore: creating TABLE "accountiam.serviceid" pg_restore: processing data for table "accountiam.apikey" pg_restore: processing data for table "accountiam.author" pg_restore: processing data for table "accountiam.flyway_schema_history" pg_restore: processing data for table "accountiam.group_binding" pg_restore: processing data for table "accountiam.idp_config" pg_restore: processing data for table "accountiam.igroup" pg_restore: processing data for table "accountiam.invited_serviceid" pg_restore: processing data for table "accountiam.invited_user" pg_restore: processing data for table "accountiam.iuser" pg_restore: processing data for table "accountiam.role" pg_restore: processing data for table "accountiam.role_binding" pg_restore: processing data for table "accountiam.scope" pg_restore: processing data for table "accountiam.serviceid" pg_restore: creating CONSTRAINT "accountiam.apikey apikey_pkey" pg_restore: creating CONSTRAINT "accountiam.apikey apikey_user_uid_serviceid_uid_name_key" pg_restore: creating CONSTRAINT "accountiam.author author_author_type_user_uid_serviceid_uid_key" pg_restore: creating CONSTRAINT "accountiam.author author_pkey" pg_restore: creating CONSTRAINT "accountiam.flyway_schema_history flyway_schema_history_pk" pg_restore: creating CONSTRAINT "accountiam.group_binding group_binding_group_uid_member_user_uid_member_serviceid_ui_key" pg_restore: creating CONSTRAINT "accountiam.group_binding group_binding_pkey" pg_restore: creating CONSTRAINT "accountiam.idp_config idp_config_pkey" pg_restore: creating CONSTRAINT "accountiam.idp_config idp_config_scope_uid_idp_realm_key" pg_restore: creating CONSTRAINT "accountiam.igroup igroup_pkey" pg_restore: creating CONSTRAINT "accountiam.igroup igroup_scope_uid_name_key" pg_restore: creating CONSTRAINT "accountiam.invited_serviceid invited_serviceid_pkey" pg_restore: creating CONSTRAINT "accountiam.invited_user invited_user_pkey" pg_restore: creating CONSTRAINT "accountiam.iuser iuser_pkey" pg_restore: creating CONSTRAINT "accountiam.iuser iuser_scope_uid_idp_config_uid_email_key" pg_restore: creating CONSTRAINT "accountiam.iuser iuser_scope_uid_idp_config_uid_idp_unique_id_key" pg_restore: creating CONSTRAINT "accountiam.role_binding role_binding_pkey" pg_restore: creating CONSTRAINT "accountiam.role_binding role_binding_scope_uid_role_uid_member_user_uid_member_serv_key" pg_restore: creating CONSTRAINT "accountiam.role role_pkey" pg_restore: creating CONSTRAINT "accountiam.role role_scope_uid_name_key" pg_restore: creating CONSTRAINT "accountiam.scope scope_pkey" pg_restore: creating CONSTRAINT "accountiam.scope scope_scope_type_scope_id_key" pg_restore: creating CONSTRAINT "accountiam.serviceid serviceid_pkey" pg_restore: creating CONSTRAINT "accountiam.serviceid serviceid_scope_uid_name_key" pg_restore: creating INDEX "accountiam.apikey_created_by_idx" pg_restore: creating INDEX "accountiam.apikey_modified_by_idx" pg_restore: creating INDEX "accountiam.apikey_scope_uid_idx" pg_restore: creating INDEX "accountiam.apikey_serviceid_uid_idx" pg_restore: creating INDEX "accountiam.apikey_user_uid_idx" pg_restore: creating INDEX "accountiam.author_serviceid_uid_idx" pg_restore: creating INDEX "accountiam.author_user_uid_idx" pg_restore: creating INDEX "accountiam.flyway_schema_history_s_idx" pg_restore: creating INDEX "accountiam.group_binding_created_by_idx" pg_restore: creating INDEX "accountiam.group_binding_group_serviceid_uids_idx" pg_restore: creating INDEX "accountiam.group_binding_modified_by_idx" pg_restore: creating INDEX "accountiam.group_binding_serviceid_uid_idx" pg_restore: creating INDEX "accountiam.group_binding_user_uid_idx" pg_restore: creating INDEX "accountiam.idp_created_by_idx" pg_restore: creating INDEX "accountiam.idp_modified_by_idx" pg_restore: creating INDEX "accountiam.idp_scope_uid_idx" pg_restore: creating INDEX "accountiam.igroup_created_by_idx" pg_restore: creating INDEX "accountiam.igroup_modified_by_idx" pg_restore: creating INDEX "accountiam.igroup_scope_uid_idx" pg_restore: creating INDEX "accountiam.invited_user_pool_user_uid" pg_restore: creating INDEX "accountiam.invited_user_scope_uid" pg_restore: creating INDEX "accountiam.iuser_created_by_idx" pg_restore: creating INDEX "accountiam.iuser_idp_config_idx" pg_restore: creating INDEX "accountiam.iuser_modified_by_idx" pg_restore: creating INDEX "accountiam.iuser_scope_uid_idx" pg_restore: creating INDEX "accountiam.role_binding_created_by_idx" pg_restore: creating INDEX "accountiam.role_binding_group_uid_idx" pg_restore: creating INDEX "accountiam.role_binding_modified_by_idx" pg_restore: creating INDEX "accountiam.role_binding_role_uid_idx" pg_restore: creating INDEX "accountiam.role_binding_scope_role_group_idx" pg_restore: creating INDEX "accountiam.role_binding_scope_role_serviceid_idx" pg_restore: creating INDEX "accountiam.role_binding_serviceid_uid_idx" pg_restore: creating INDEX "accountiam.role_binding_user_uid_idx" pg_restore: creating INDEX "accountiam.role_created_by_idx" pg_restore: creating INDEX "accountiam.role_modified_by_idx" pg_restore: creating INDEX "accountiam.role_scope_uid_idx" pg_restore: creating INDEX "accountiam.scope_parent_scope_uid_idx" pg_restore: creating INDEX "accountiam.scope_product_scope_uid_idx" pg_restore: creating INDEX "accountiam.serviceid_created_by_idx" pg_restore: creating INDEX "accountiam.serviceid_modified_by_idx" pg_restore: creating INDEX "accountiam.serviceid_scope_uid_idx" pg_restore: creating FK CONSTRAINT "accountiam.apikey apikey_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.apikey apikey_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.apikey apikey_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.apikey apikey_serviceid_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.apikey apikey_user_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.author author_serviceid_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.author author_user_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.group_binding group_binding_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.group_binding group_binding_group_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.group_binding group_binding_member_serviceid_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.group_binding group_binding_member_user_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.group_binding group_binding_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.idp_config idp_config_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.idp_config idp_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.idp_config idp_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.igroup igroup_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.igroup igroup_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.igroup igroup_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_serviceid invited_serviceid_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_serviceid invited_serviceid_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_serviceid invited_serviceid_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_serviceid invited_serviceid_serviceid_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_user invited_user_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_user invited_user_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_user invited_user_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.invited_user invited_user_user_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.iuser iuser_idp_config_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.iuser iuser_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role_binding role_binding_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role_binding role_binding_member_group_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role_binding role_binding_member_serviceid_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role_binding role_binding_member_user_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role_binding role_binding_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role_binding role_binding_role_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role_binding role_binding_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role role_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role role_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.role role_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.scope scope_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.scope scope_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.scope scope_parent_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.scope scope_product_scope_uid_index_fk" pg_restore: creating FK CONSTRAINT "accountiam.serviceid serviceid_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.serviceid serviceid_modified_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.serviceid serviceid_scope_uid_fkey" pg_restore: creating FK CONSTRAINT "accountiam.iuser user_created_by_fkey" pg_restore: creating FK CONSTRAINT "accountiam.iuser user_modified_by_fkey" pg_restore: creating ACL "SCHEMA accountiam" pg_restore: creating DEFAULT ACL "accountiam.DEFAULT PRIVILEGES FOR SEQUENCES" pg_restore: creating DEFAULT ACL "accountiam.DEFAULT PRIVILEGES FOR TYPES" pg_restore: creating DEFAULT ACL "accountiam.DEFAULT PRIVILEGES FOR FUNCTIONS" pg_restore: creating DEFAULT ACL "accountiam.DEFAULT PRIVILEGES FOR TABLES" List of databases Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges -------------+----------+----------+-----------------+---------+-------+------------+-----------+----------------------------- account_iam | postgres | UTF8 | libc | C | C | | | postgres=CTc/postgres + | | | | | | | | user_accountiam=Tc/postgres cloudpak | cpadmin | UTF8 | libc | C | C | | | im | im_user | UTF8 | libc | C | C | | | =Tc/im_user + | | | | | | | | im_user=CTc/im_user postgres | postgres | UTF8 | libc | C | C | | | template0 | postgres | UTF8 | libc | C | C | | | =c/postgres + | | | | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | libc | C | C | | | =c/postgres + | | | | | | | | postgres=CTc/postgres zen | zen_user | UTF8 | libc | C | C | | | =Tc/zen_user + | | | | | | | | zen_user=CTc/zen_user (7 rows) List of schemas Name | Owner --------+------------------- public | pg_database_owner (1 row) List of roles Role name | Attributes -------------------+------------------------------------------------------------ cpadmin | im_user | postgres | Superuser, Create role, Create DB, Replication, Bypass RLS streaming_replica | Replication user_accountiam | zen_user | [INFO] Rerunning OIDC registration job... job.batch "oidc-client-registration" deleted [INFO] Wait for previous job to delete... Warning: resource jobs/oidc-client-registration is missing the kubectl.kubernetes.io/last-applied-configuration annotation which is required by oc apply. oc apply should only be used on resources created declaratively by either oc create --save-config or oc apply. The missing annotation will be patched automatically. job.batch/oidc-client-registration configured [INFO] Waiting for job oidc-client-registration to complete in namespace test. [INFO] Job oidc-client-registration completed. [✔] Restore completed successfully. ``` This is how you dropdown.
bluzarraga commented 1 month ago

may need to label the bootstrap secret as well

qpdpQ commented 1 month ago 
allen@Allens-MBP restore % velero restore get                      
NAME                             BACKUP                                STATUS            STARTED                         COMPLETED                       ERRORS   WARNINGS   CREATED                         SELECTOR
restore-catalog                  commonservice-backup-20240821172729   Completed         2024-08-21 14:10:50 -0400 EDT   2024-08-21 14:11:08 -0400 EDT   0        0          2024-08-21 14:10:50 -0400 EDT   foundationservices.cloudpak.ibm.com=catalog
restore-cert-manager             commonservice-backup-20240821172729   Completed         2024-08-21 14:29:25 -0400 EDT   2024-08-21 14:30:03 -0400 EDT   0        3          2024-08-21 14:29:25 -0400 EDT   foundationservices.cloudpak.ibm.com=cert-manager
restore-commonservice            commonservice-backup-20240821172729   Completed         2024-08-21 14:12:13 -0400 EDT   2024-08-21 14:12:30 -0400 EDT   0        0          2024-08-21 14:12:13 -0400 EDT   foundationservices.cloudpak.ibm.com=commonservice
restore-configmap                commonservice-backup-20240821172729   Completed         2024-08-21 14:11:26 -0400 EDT   2024-08-21 14:11:43 -0400 EDT   0        0          2024-08-21 14:11:16 -0400 EDT   foundationservices.cloudpak.ibm.com=configmap
restore-crd                      commonservice-backup-20240821172729   Completed         2024-08-21 14:11:43 -0400 EDT   2024-08-21 14:12:02 -0400 EDT   0        0          2024-08-21 14:11:23 -0400 EDT   foundationservices.cloudpak.ibm.com=crd
restore-cs-db-data               commonservice-backup-20240821172729   Completed         2024-08-21 15:37:45 -0400 EDT   2024-08-21 15:38:06 -0400 EDT   0        7          2024-08-21 15:37:45 -0400 EDT   foundationservices.cloudpak.ibm.com=cs-db-data
restore-entitlementkey           commonservice-backup-20240821172729   Completed         2024-08-21 14:07:53 -0400 EDT   2024-08-21 14:08:19 -0400 EDT   0        0          2024-08-21 14:07:53 -0400 EDT   foundationservices.cloudpak.ibm.com=entitlementkey
restore-namespace                commonservice-backup-20240821172729   PartiallyFailed   2024-08-21 14:07:23 -0400 EDT   2024-08-21 14:07:41 -0400 EDT   1        0          2024-08-21 14:07:23 -0400 EDT   foundationservices.cloudpak.ibm.com=namespace
restore-operands                 commonservice-backup-20240821172729   Completed         2024-08-21 14:44:35 -0400 EDT   2024-08-21 14:44:55 -0400 EDT   0        0          2024-08-21 14:44:35 -0400 EDT   foundationservices.cloudpak.ibm.com=operand
restore-operatorgroup            commonservice-backup-20240821172729   Completed         2024-08-21 14:11:08 -0400 EDT   2024-08-21 14:11:26 -0400 EDT   0        0          2024-08-21 14:11:07 -0400 EDT   foundationservices.cloudpak.ibm.com=operatorgroup
restore-pull-secret              commonservice-backup-20240821172729   Completed         2024-08-21 14:08:19 -0400 EDT   2024-08-21 14:08:22 -0400 EDT   0        1          2024-08-21 14:08:06 -0400 EDT   foundationservices.cloudpak.ibm.com=pull-secret
restore-singleton-subscription   commonservice-backup-20240821172729   Completed         2024-08-21 14:12:40 -0400 EDT   2024-08-21 14:12:58 -0400 EDT   0        0          2024-08-21 14:12:40 -0400 EDT   foundationservices.cloudpak.ibm.com=singleton-subscription
restore-subscription             commonservice-backup-20240821172729   Completed         2024-08-21 14:35:58 -0400 EDT   2024-08-21 14:36:17 -0400 EDT   0        0          2024-08-21 14:35:58 -0400 EDT   foundationservices.cloudpak.ibm.com=subscription
restore-user-mgmt                commonservice-backup-20240821172729   Completed         2024-08-21 16:39:11 -0400 EDT   2024-08-21 16:39:32 -0400 EDT   0        0          2024-08-21 16:39:11 -0400 EDT   foundationservices.cloudpak.ibm.com=user-mgmt

All the data got restored with oadp

qpdpQ commented 1 month ago

cs-db-restore-job works for mcsp-br, no other workaround needed.

It is ready for review now

YCShen1010 commented 4 weeks ago

Backup and restore user management in the same cluster, and passed

sh-4.4$ cat backup_log_20240919133442.log
[INFO] Mode set to backup, beginning backup process.
[INFO] Beginning backup of cloudpak database...
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined access methods
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension tables
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: flagging inherited columns in subtables
pg_dump: reading partitioning data
pg_dump: reading indexes
pg_dump: flagging indexes in partitioned tables
pg_dump: reading extended statistics
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading rewrite rules
pg_dump: reading policies
pg_dump: reading row-level security policies
pg_dump: reading publications
pg_dump: reading publication membership of tables
pg_dump: reading publication membership of schemas
pg_dump: reading subscriptions
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: saving search_path = 
pg_dump: saving database definition
[INFO] Beginning backup of im database...
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members

....

pg_dump: reading row-level security policies
pg_dump: reading publications
pg_dump: reading publication membership of tables
pg_dump: reading publication membership of schemas
pg_dump: reading subscriptions
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: saving search_path = 
pg_dump: saving database definition
pg_dump: dumping contents of table "accountiam.apikey"
pg_dump: dumping contents of table "accountiam.assistant_key"
pg_dump: dumping contents of table "accountiam.author"
pg_dump: dumping contents of table "accountiam.flyway_schema_history"
pg_dump: dumping contents of table "accountiam.group_binding"
pg_dump: dumping contents of table "accountiam.idp_config"
pg_dump: dumping contents of table "accountiam.igroup"
pg_dump: dumping contents of table "accountiam.invited_serviceid"
pg_dump: dumping contents of table "accountiam.invited_user"
pg_dump: dumping contents of table "accountiam.iuser"
pg_dump: dumping contents of table "accountiam.role"
pg_dump: dumping contents of table "accountiam.role_binding"
pg_dump: dumping contents of table "accountiam.scope"
pg_dump: dumping contents of table "accountiam.serviceid"
pg_dump: dumping contents of table "accountiam.tracked_key"
[INFO] Copy backup file.
Defaulted container "postgres" out of: postgres, bootstrap-controller (init)
tar: Removing leading `/' from member names
Defaulted container "postgres" out of: postgres, bootstrap-controller (init)
tar: Removing leading `/' from member names
Defaulted container "postgres" out of: postgres, bootstrap-controller (init)
tar: Removing leading `/' from member names
Defaulted container "postgres" out of: postgres, bootstrap-controller (init)
tar: Removing leading `/' from member names
[✔] Backup completed successfully.
ibm-ci-bot commented 4 weeks ago

[APPROVALNOTIFIER] This PR is APPROVED

This pull-request has been approved by: qpdpQ, YCShen1010

The full list of commands accepted by this bot can be found here.

The pull request process is described here

Needs approval from an approver in each of these files: - ~~[OWNERS](https://github.com/IBM/ibm-common-service-operator/blob/scripts-dev/OWNERS)~~ [YCShen1010,qpdpQ] Approvers can indicate their approval by writing `/approve` in a comment Approvers can cancel approval by writing `/approve cancel` in a comment