一、需求描述
金仓V8 R6数据库,需要编写自动备份shell脚本。
二、需要手动输入密码的备份脚本文件
export PGPASSWORD="Szzfaky@mgt123"
DATE=$(date +"%Y%m%d_%H%M%S")
BACKUP_FILE="/data/backup/test_${DATE}.dmp"
/home/kingbase/KingbaseES/V8/KESRealPro/V008R006C008B0014/ClientTools/bin/sys_dump -h localhost -p 54321 -U system -v -f "${BACKUP_FILE}" -F c test
三、无需手动输入密码的自动备份脚本
#!/usr/bin/expect
set password "Szzfaky@mgt123"
log_file /data/backup/expect_log.txt
set timeout 600
spawn date +"%Y%m%d_%H%M%S"
expect -re "(.*)n"
set DATE $expect_out(1,string)
regsub "r" $DATE "" DATE
set BACKUP_FILE "/data/backup/test_${DATE}.dmp"
spawn /home/kingbase/KingbaseES/V8/KESRealPro/V008R006C008B0014/ClientTools/bin/sys_dump -h localhost -p 54321-U system -v -f "$BACKUP_FILE" -F c test
expect "Password:"
send "$passwordr"
expect eof
root@host-192-168-66-18 backup]# ./9.sh
spawn date +"%Y%m%d_%H%M%S"
"20231012_133207"
spawn /home/kingbase/KingbaseES/V8/KESRealPro/V008R006C008B0014/ClientTools/bin/sys_dump -h localhost -p 54321 -U system -v -f /data/backup/test_"20231012_133207".dmp -F c test
Password:
sys_dump: last built-in OID is 16383
sys_dump: reading extensions
sys_dump: identifying extension members
sys_dump: reading schemas
sys_dump: reading user-defined tables
sys_dump: reading user-defined functions
sys_dump: reading user-defined types
sys_dump: reading procedural languages
sys_dump: reading user-defined aggregate functions
sys_dump: reading user-defined operators
sys_dump: reading user-defined access methods
sys_dump: reading user-defined operator classes
sys_dump: reading user-defined operator families
sys_dump: reading user-defined text search parsers
sys_dump: reading user-defined text search templates
sys_dump: reading user-defined text search dictionaries
sys_dump: reading user-defined text search configurations
sys_dump: reading user-defined foreign-data wrappers
sys_dump: reading user-defined foreign servers
sys_dump: reading default privileges
sys_dump: reading user-defined collations
sys_dump: reading user-defined conversions
sys_dump: reading type casts
sys_dump: reading transforms
sys_dump: reading table inheritance information
sys_dump: reading event triggers
sys_dump: finding extension tables
sys_dump: finding inheritance relationships
sys_dump: reading user tables which applied policy
sys_dump: reading column info for interesting tables
sys_dump: finding the columns and types of table "pg_catalog.sys_anon_policy"
sys_dump: finding the columns and types of table "pg_catalog.sys_audit_blocklog"
sys_dump: finding the columns and types of table "pg_catalog.sys_audit_userlog"
sys_dump: finding the columns and types of table "pg_catalog.sys_database_link"
sys_dump: finding the columns and types of table "pg_catalog.sys_directory"
sys_dump: finding the columns and types of table "pg_catalog.sys_package"
sys_dump: finding the columns and types of table "pg_catalog.sys_pkgitem"
sys_dump: finding the columns and types of table "pg_catalog.sys_privilege"
sys_dump: finding the columns and types of table "pg_catalog.sys_protect"
sys_dump: finding the columns and types of table "pg_catalog.sys_pwdht_shadow"
sys_dump: finding the columns and types of table "pg_catalog.sys_query_mapping"
sys_dump: finding the columns and types of table "pg_catalog.sys_recyclebin"
sys_dump: finding the columns and types of table "pg_catalog.sys_role_disable"
sys_dump: finding the columns and types of table "pg_catalog.sys_synonym"
sys_dump: finding the columns and types of table "pg_catalog.sys_sysaudit_ids_setting"
sys_dump: finding the columns and types of table "pg_catalog.sys_sysaudit_setting"
sys_dump: finding the columns and types of table "pg_catalog.sys_sysprivilege"
sys_dump: finding the columns and types of table "pg_catalog.kdb_job"
sys_dump: finding the columns and types of table "sys_catalog.kdb_ce_col"
sys_dump: finding the columns and types of table "sys_catalog.kdb_ce_col_key"
sys_dump: finding the columns and types of table "sys_catalog.kdb_ce_col_key_arg"
sys_dump: finding the columns and types of table "sys_catalog.kdb_ce_mst_key"
sys_dump: finding the columns and types of table "sys_catalog.kdb_ce_mst_key_arg"
sys_dump: finding the columns and types of table "sys_catalog.kdb_ce_proc"
sys_dump: finding the columns and types of table "sys_catalog.sys_aggregate"
sys_dump: finding the columns and types of table "sys_catalog.sys_am"
sys_dump: finding the columns and types of table "sys_catalog.sys_amop"
sys_dump: finding the columns and types of table "sys_catalog.sys_amproc"
sys_dump: finding the columns and types of table "sys_catalog.sys_attrdef"
sys_dump: finding the columns and types of table "sys_catalog.sys_attribute"
sys_dump: finding the columns and types of table "sys_catalog.sys_auth_members"
sys_dump: finding the columns and types of table "sys_catalog.sys_cast"
sys_dump: finding the columns and types of table "sys_catalog.sys_class"
sys_dump: finding the columns and types of table "sys_catalog.sys_collation"
sys_dump: finding the columns and types of table "sys_catalog.sys_context"
sys_dump: finding the columns and types of table "sys_catalog.sys_conversion"
sys_dump: finding the columns and types of table "sys_catalog.sys_database"
sys_dump: finding the columns and types of table "sys_catalog.sys_default_acl"
sys_dump: finding the columns and types of table "sys_catalog.sys_depend"
sys_dump: finding the columns and types of table "sys_catalog.sys_description"
sys_dump: finding the columns and types of table "sys_catalog.sys_enum"
sys_dump: finding the columns and types of table "sys_catalog.sys_event_trigger"
sys_dump: finding the columns and types of table "sys_catalog.sys_extension"
sys_dump: finding the columns and types of table "sys_catalog.sys_foreign_data_wrapper"
sys_dump: finding the columns and types of table "sys_catalog.sys_foreign_server"
sys_dump: finding the columns and types of table "sys_catalog.sys_foreign_table"
sys_dump: finding the columns and types of table "sys_catalog.sys_index"
sys_dump: finding the columns and types of table "sys_catalog.sys_inherits"
sys_dump: finding the columns and types of table "sys_catalog.sys_init_privs"
sys_dump: finding the columns and types of table "sys_catalog.sys_language"
sys_dump: finding the columns and types of table "sys_catalog.sys_largeobject_metadata"
sys_dump: finding the columns and types of table "sys_catalog.sys_objects"
sys_dump: finding the columns and types of table "sys_catalog.sys_opclass"
sys_dump: finding the columns and types of table "sys_catalog.sys_operator"
sys_dump: finding the columns and types of table "sys_catalog.sys_opfamily"
sys_dump: finding the columns and types of table "sys_catalog.sys_partitioned_table"
sys_dump: finding the columns and types of table "sys_catalog.sys_pltemplate"
sys_dump: finding the columns and types of table "sys_catalog.sys_policy"
sys_dump: finding the columns and types of table "sys_catalog.sys_proc"
sys_dump: finding the columns and types of table "sys_catalog.sys_publication"
sys_dump: finding the columns and types of table "sys_catalog.sys_publication_rel"
sys_dump: finding the columns and types of table "sys_catalog.sys_range"
sys_dump: finding the columns and types of table "sys_catalog.sys_replication_origin"
sys_dump: finding the columns and types of table "sys_catalog.sys_rewrite"
sys_dump: finding the columns and types of table "sys_catalog.sys_seclabel"
sys_dump: finding the columns and types of table "sys_catalog.sys_sequence"
sys_dump: finding the columns and types of table "sys_catalog.sys_shdepend"
sys_dump: finding the columns and types of table "sys_catalog.sys_shdescription"
sys_dump: finding the columns and types of table "sys_catalog.sys_shseclabel"
sys_dump: finding the columns and types of table "sys_catalog.sys_statistic_ext"
sys_dump: finding the columns and types of table "sys_catalog.sys_subpartition_table"
sys_dump: finding the columns and types of table "sys_catalog.sys_subscription_rel"
sys_dump: finding the columns and types of table "sys_catalog.sys_tablespace"
sys_dump: finding the columns and types of table "sys_catalog.sys_transform"
sys_dump: finding the columns and types of table "sys_catalog.sys_trigger"
sys_dump: finding the columns and types of table "sys_catalog.sys_ts_config"
sys_dump: finding the columns and types of table "sys_catalog.sys_ts_config_map"
sys_dump: finding the columns and types of table "sys_catalog.sys_ts_dict"
sys_dump: finding the columns and types of table "sys_catalog.sys_ts_parser"
sys_dump: finding the columns and types of table "sys_catalog.sys_ts_template"
sys_dump: finding the columns and types of table "sys_catalog.sys_type"
sys_dump: finding the columns and types of table "sys_catalog.sys_protect"
sys_dump: finding the columns and types of table "sys_catalog.sys_object_status"
sys_dump: finding the columns and types of table "pg_catalog.pg_triggers"
sys_dump: finding the columns and types of table "sys_catalog.sys_triggers"
sys_dump: finding the columns and types of table "pg_catalog.sys_depends"
sys_dump: finding the columns and types of table "sys_catalog.sys_namespace"
sys_dump: finding the columns and types of table "sys_catalog.sys_constraint"
sys_dump: finding the columns and types of table "sys_catalog.sys_constraint_status"
sys_dump: finding the columns and types of table "sys_catalog.sys_available_extensions"
sys_dump: finding the columns and types of table "sys_catalog.sys_available_extension_versions"
sys_dump: finding the columns and types of table "sys_catalog.sys_cursors"
sys_dump: finding the columns and types of table "sys_catalog.sys_group"
sys_dump: finding the columns and types of table "sys_catalog.sys_indexes"
sys_dump: finding the columns and types of table "sys_catalog.sys_locks"
sys_dump: finding the columns and types of table "sys_catalog.sys_matviews"
sys_dump: finding the columns and types of table "sys_catalog.sys_policies"
sys_dump: finding the columns and types of table "sys_catalog.sys_prepared_statements"
sys_dump: finding the columns and types of table "sys_catalog.sys_prepared_xacts"
sys_dump: finding the columns and types of table "sys_catalog.sys_publication_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_replication_slots"
sys_dump: finding the columns and types of table "sys_catalog.sys_roles"
sys_dump: finding the columns and types of table "sys_catalog.sys_rules"
sys_dump: finding the columns and types of table "sys_catalog.sys_seclabels"
sys_dump: finding the columns and types of table "sys_catalog.sys_sequences"
sys_dump: finding the columns and types of table "sys_catalog.sys_settings"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_activity"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_instio"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_instevent"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_instlock"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_sqltime"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_sqlwait"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_sqlio"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_shmem"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_msgaccum"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_waitaccum"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_cached_plans"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_all_indexes"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_all_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_archiver"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_wal_buffer"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_bgwriter"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_database"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_database_conflicts"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_gssapi"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_progress_cluster"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_progress_create_index"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_progress_vacuum"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_replication"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_ssl"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_subscription"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_sys_indexes"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_sys_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_user_functions"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_user_indexes"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_user_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_wal_receiver"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_xact_all_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_xact_sys_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_xact_user_functions"
sys_dump: finding the columns and types of table "sys_catalog.sys_stat_xact_user_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_all_indexes"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_all_sequences"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_all_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_sys_indexes"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_sys_sequences"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_sys_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_user_indexes"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_user_sequences"
sys_dump: finding the columns and types of table "sys_catalog.sys_statio_user_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_stats"
sys_dump: finding the columns and types of table "sys_catalog.sys_stats_ext"
sys_dump: finding the columns and types of table "sys_catalog.sys_tables"
sys_dump: finding the columns and types of table "sys_catalog.sys_timezone_abbrevs"
sys_dump: finding the columns and types of table "sys_catalog.sys_timezone_names"
sys_dump: finding the columns and types of table "sys_catalog.sys_user"
sys_dump: finding the columns and types of table "sys_catalog.sys_users"
sys_dump: finding the columns and types of table "sys_catalog.sys_user_mappings"
sys_dump: finding the columns and types of table "sys_catalog.sys_views"
sys_dump: finding the columns and types of table "pg_catalog.recyclebin"
sys_dump: finding the columns and types of table "pg_catalog.user_any_privs"
sys_dump: finding the columns and types of table "pg_catalog.sys_resource_groups"
sys_dump: finding the columns and types of table "pg_catalog.sys_resgroup"
sys_dump: finding the columns and types of table "sys.dual"
sys_dump: finding the columns and types of table "sys.user_objects"
sys_dump: finding the columns and types of table "sys.all_objects"
sys_dump: finding the columns and types of table "sys.user_types"
sys_dump: finding the columns and types of table "sys.all_types"
sys_dump: finding the columns and types of table "sys.user_tables"
sys_dump: finding the columns and types of table "sys.all_tables"
sys_dump: finding the columns and types of table "sys.user_all_tables"
sys_dump: finding the columns and types of table "sys.all_all_tables"
sys_dump: finding the columns and types of table "sys.user_col_privs"
sys_dump: finding the columns and types of table "sys.all_col_privs"
sys_dump: finding the columns and types of table "sys.ALL_CONSTRAINTS"
sys_dump: finding the columns and types of table "sys.user_constraints"
sys_dump: finding the columns and types of table "sys.all_tab_cols"
sys_dump: finding the columns and types of table "sys.user_tab_cols"
sys_dump: finding the columns and types of table "sys.user_table_cols"
sys_dump: finding the columns and types of table "sys.USER_INDEXES"
sys_dump: finding the columns and types of table "sys.ALL_INDEXES"
sys_dump: finding the columns and types of table "sys.user_tab_columns"
sys_dump: finding the columns and types of table "sys.all_tab_columns"
sys_dump: finding the columns and types of table "sys.all_ind_columns"
sys_dump: finding the columns and types of table "sys.user_ind_columns"
sys_dump: finding the columns and types of table "sys.user_views"
sys_dump: finding the columns and types of table "sys.all_views"
sys_dump: finding the columns and types of table "sys.all_sequences"
sys_dump: finding the columns and types of table "sys.user_sequences"
sys_dump: finding the columns and types of table "sys.all_triggers"
sys_dump: finding the columns and types of table "sys.user_triggers"
sys_dump: finding the columns and types of table "sys.all_source"
sys_dump: finding the columns and types of table "sys.user_source"
sys_dump: finding the columns and types of table "sys.user_tablespace"
sys_dump: finding the columns and types of table "sys.user_tablespaces"
sys_dump: finding the columns and types of table "sys.all_users"
sys_dump: finding the columns and types of table "sys.user_users"
sys_dump: finding the columns and types of table "sys.all_tab_privs"
sys_dump: finding the columns and types of table "sys.user_tab_privs"
sys_dump: finding the columns and types of table "sys.all_cons_columns"
sys_dump: finding the columns and types of table "sys.user_cons_columns"
sys_dump: finding the columns and types of table "sys.user_role_privs"
sys_dump: finding the columns and types of table "sys.all_tab_comments"
sys_dump: finding the columns and types of table "sys.user_tab_comments"
sys_dump: finding the columns and types of table "sys.all_col_comments"
sys_dump: finding the columns and types of table "sys.user_col_comments"
sys_dump: finding the columns and types of table "sys.all_part_tables"
sys_dump: finding the columns and types of table "sys.user_part_tables"
sys_dump: finding the columns and types of table "sys.all_tab_partitions"
sys_dump: finding the columns and types of table "sys.user_tab_partitions"
sys_dump: finding the columns and types of table "sys.all_trigger_cols"
sys_dump: finding the columns and types of table "sys.user_trigger_cols"
sys_dump: finding the columns and types of table "sys.user_synonyms"
sys_dump: finding the columns and types of table "sys.all_synonyms"
sys_dump: finding the columns and types of table "sys.user_db_links"
sys_dump: finding the columns and types of table "sys.all_db_links"
sys_dump: finding the columns and types of table "sys.user_directories"
sys_dump: finding the columns and types of table "sys.all_directories"
sys_dump: finding the columns and types of table "sys.sys_session"
sys_dump: finding the columns and types of table "sys_catalog.sys_space_quota"
sys_dump: finding the columns and types of table "pg_catalog.all_arguments"
sys_dump: finding the columns and types of table "pg_catalog.user_arguments"
sys_dump: flagging inherited columns in subtables
sys_dump: reading indexes
sys_dump: reading indexes for table "pg_catalog.sys_anon_policy"
sys_dump: reading indexes for table "pg_catalog.sys_audit_blocklog"
sys_dump: reading indexes for table "pg_catalog.sys_audit_userlog"
sys_dump: reading indexes for table "pg_catalog.sys_database_link"
sys_dump: reading indexes for table "pg_catalog.sys_directory"
sys_dump: reading indexes for table "pg_catalog.sys_package"
sys_dump: reading indexes for table "pg_catalog.sys_pkgitem"
sys_dump: reading indexes for table "pg_catalog.sys_privilege"
sys_dump: reading indexes for table "pg_catalog.sys_protect"
sys_dump: reading indexes for table "pg_catalog.sys_pwdht_shadow"
sys_dump: reading indexes for table "pg_catalog.sys_query_mapping"
sys_dump: reading indexes for table "pg_catalog.sys_recyclebin"
sys_dump: reading indexes for table "pg_catalog.sys_role_disable"
sys_dump: reading indexes for table "pg_catalog.sys_synonym"
sys_dump: reading indexes for table "pg_catalog.sys_sysaudit_ids_setting"
sys_dump: reading indexes for table "pg_catalog.sys_sysaudit_setting"
sys_dump: reading indexes for table "pg_catalog.sys_sysprivilege"
sys_dump: reading indexes for table "pg_catalog.kdb_job"
sys_dump: reading indexes for table "sys_catalog.kdb_ce_col"
sys_dump: reading indexes for table "sys_catalog.kdb_ce_col_key"
sys_dump: reading indexes for table "sys_catalog.kdb_ce_col_key_arg"
sys_dump: reading indexes for table "sys_catalog.kdb_ce_mst_key"
sys_dump: reading indexes for table "sys_catalog.kdb_ce_mst_key_arg"
sys_dump: reading indexes for table "sys_catalog.kdb_ce_proc"
sys_dump: reading indexes for table "sys_catalog.sys_aggregate"
sys_dump: reading indexes for table "sys_catalog.sys_am"
sys_dump: reading indexes for table "sys_catalog.sys_amop"
sys_dump: reading indexes for table "sys_catalog.sys_amproc"
sys_dump: reading indexes for table "sys_catalog.sys_attrdef"
sys_dump: reading indexes for table "sys_catalog.sys_attribute"
sys_dump: reading indexes for table "sys_catalog.sys_auth_members"
sys_dump: reading indexes for table "sys_catalog.sys_cast"
sys_dump: reading indexes for table "sys_catalog.sys_class"
sys_dump: reading indexes for table "sys_catalog.sys_collation"
sys_dump: reading indexes for table "sys_catalog.sys_context"
sys_dump: reading indexes for table "sys_catalog.sys_conversion"
sys_dump: reading indexes for table "sys_catalog.sys_database"
sys_dump: reading indexes for table "sys_catalog.sys_default_acl"
sys_dump: reading indexes for table "sys_catalog.sys_depend"
sys_dump: reading indexes for table "sys_catalog.sys_description"
sys_dump: reading indexes for table "sys_catalog.sys_enum"
sys_dump: reading indexes for table "sys_catalog.sys_event_trigger"
sys_dump: reading indexes for table "sys_catalog.sys_extension"
sys_dump: reading indexes for table "sys_catalog.sys_foreign_data_wrapper"
sys_dump: reading indexes for table "sys_catalog.sys_foreign_server"
sys_dump: reading indexes for table "sys_catalog.sys_foreign_table"
sys_dump: reading indexes for table "sys_catalog.sys_index"
sys_dump: reading indexes for table "sys_catalog.sys_inherits"
sys_dump: reading indexes for table "sys_catalog.sys_init_privs"
sys_dump: reading indexes for table "sys_catalog.sys_language"
sys_dump: reading indexes for table "sys_catalog.sys_largeobject_metadata"
sys_dump: reading indexes for table "sys_catalog.sys_objects"
sys_dump: reading indexes for table "sys_catalog.sys_opclass"
sys_dump: reading indexes for table "sys_catalog.sys_operator"
sys_dump: reading indexes for table "sys_catalog.sys_opfamily"
sys_dump: reading indexes for table "sys_catalog.sys_partitioned_table"
sys_dump: reading indexes for table "sys_catalog.sys_pltemplate"
sys_dump: reading indexes for table "sys_catalog.sys_policy"
sys_dump: reading indexes for table "sys_catalog.sys_proc"
sys_dump: reading indexes for table "sys_catalog.sys_publication"
sys_dump: reading indexes for table "sys_catalog.sys_publication_rel"
sys_dump: reading indexes for table "sys_catalog.sys_range"
sys_dump: reading indexes for table "sys_catalog.sys_replication_origin"
sys_dump: reading indexes for table "sys_catalog.sys_rewrite"
sys_dump: reading indexes for table "sys_catalog.sys_seclabel"
sys_dump: reading indexes for table "sys_catalog.sys_sequence"
sys_dump: reading indexes for table "sys_catalog.sys_shdepend"
sys_dump: reading indexes for table "sys_catalog.sys_shdescription"
sys_dump: reading indexes for table "sys_catalog.sys_shseclabel"
sys_dump: reading indexes for table "sys_catalog.sys_statistic_ext"
sys_dump: reading indexes for table "sys_catalog.sys_subpartition_table"
sys_dump: reading indexes for table "sys_catalog.sys_subscription_rel"
sys_dump: reading indexes for table "sys_catalog.sys_tablespace"
sys_dump: reading indexes for table "sys_catalog.sys_transform"
sys_dump: reading indexes for table "sys_catalog.sys_trigger"
sys_dump: reading indexes for table "sys_catalog.sys_ts_config"
sys_dump: reading indexes for table "sys_catalog.sys_ts_config_map"
sys_dump: reading indexes for table "sys_catalog.sys_ts_dict"
sys_dump: reading indexes for table "sys_catalog.sys_ts_parser"
sys_dump: reading indexes for table "sys_catalog.sys_ts_template"
sys_dump: reading indexes for table "sys_catalog.sys_type"
sys_dump: reading indexes for table "sys_catalog.sys_protect"
sys_dump: reading indexes for table "sys_catalog.sys_object_status"
sys_dump: reading indexes for table "pg_catalog.pg_triggers"
sys_dump: reading indexes for table "sys_catalog.sys_triggers"
sys_dump: reading indexes for table "pg_catalog.sys_depends"
sys_dump: reading indexes for table "sys_catalog.sys_namespace"
sys_dump: reading indexes for table "sys_catalog.sys_constraint"
sys_dump: reading indexes for table "sys_catalog.sys_constraint_status"
sys_dump: reading indexes for table "sys_catalog.sys_available_extensions"
sys_dump: reading indexes for table "sys_catalog.sys_available_extension_versions"
sys_dump: reading indexes for table "sys_catalog.sys_cursors"
sys_dump: reading indexes for table "sys_catalog.sys_group"
sys_dump: reading indexes for table "sys_catalog.sys_indexes"
sys_dump: reading indexes for table "sys_catalog.sys_locks"
sys_dump: reading indexes for table "sys_catalog.sys_matviews"
sys_dump: reading indexes for table "sys_catalog.sys_policies"
sys_dump: reading indexes for table "sys_catalog.sys_prepared_statements"
sys_dump: reading indexes for table "sys_catalog.sys_prepared_xacts"
sys_dump: reading indexes for table "sys_catalog.sys_publication_tables"
sys_dump: reading indexes for table "sys_catalog.sys_replication_slots"
sys_dump: reading indexes for table "sys_catalog.sys_roles"
sys_dump: reading indexes for table "sys_catalog.sys_rules"
sys_dump: reading indexes for table "sys_catalog.sys_seclabels"
sys_dump: reading indexes for table "sys_catalog.sys_sequences"
sys_dump: reading indexes for table "sys_catalog.sys_settings"
sys_dump: reading indexes for table "sys_catalog.sys_stat_activity"
sys_dump: reading indexes for table "sys_catalog.sys_stat_instio"
sys_dump: reading indexes for table "sys_catalog.sys_stat_instevent"
sys_dump: reading indexes for table "sys_catalog.sys_stat_instlock"
sys_dump: reading indexes for table "sys_catalog.sys_stat_sqltime"
sys_dump: reading indexes for table "sys_catalog.sys_stat_sqlwait"
sys_dump: reading indexes for table "sys_catalog.sys_stat_sqlio"
sys_dump: reading indexes for table "sys_catalog.sys_stat_shmem"
sys_dump: reading indexes for table "sys_catalog.sys_stat_msgaccum"
sys_dump: reading indexes for table "sys_catalog.sys_stat_waitaccum"
sys_dump: reading indexes for table "sys_catalog.sys_stat_cached_plans"
sys_dump: reading indexes for table "sys_catalog.sys_stat_all_indexes"
sys_dump: reading indexes for table "sys_catalog.sys_stat_all_tables"
sys_dump: reading indexes for table "sys_catalog.sys_stat_archiver"
sys_dump: reading indexes for table "sys_catalog.sys_stat_wal_buffer"
sys_dump: reading indexes for table "sys_catalog.sys_stat_bgwriter"
sys_dump: reading indexes for table "sys_catalog.sys_stat_database"
sys_dump: reading indexes for table "sys_catalog.sys_stat_database_conflicts"
sys_dump: reading indexes for table "sys_catalog.sys_stat_gssapi"
sys_dump: reading indexes for table "sys_catalog.sys_stat_progress_cluster"
sys_dump: reading indexes for table "sys_catalog.sys_stat_progress_create_index"
sys_dump: reading indexes for table "sys_catalog.sys_stat_progress_vacuum"
sys_dump: reading indexes for table "sys_catalog.sys_stat_replication"
sys_dump: reading indexes for table "sys_catalog.sys_stat_ssl"
sys_dump: reading indexes for table "sys_catalog.sys_stat_subscription"
sys_dump: reading indexes for table "sys_catalog.sys_stat_sys_indexes"
sys_dump: reading indexes for table "sys_catalog.sys_stat_sys_tables"
sys_dump: reading indexes for table "sys_catalog.sys_stat_user_functions"
sys_dump: reading indexes for table "sys_catalog.sys_stat_user_indexes"
sys_dump: reading indexes for table "sys_catalog.sys_stat_user_tables"
sys_dump: reading indexes for table "sys_catalog.sys_stat_wal_receiver"
sys_dump: reading indexes for table "sys_catalog.sys_stat_xact_all_tables"
sys_dump: reading indexes for table "sys_catalog.sys_stat_xact_sys_tables"
sys_dump: reading indexes for table "sys_catalog.sys_stat_xact_user_functions"
sys_dump: reading indexes for table "sys_catalog.sys_stat_xact_user_tables"
sys_dump: reading indexes for table "sys_catalog.sys_statio_all_indexes"
sys_dump: reading indexes for table "sys_catalog.sys_statio_all_sequences"
sys_dump: reading indexes for table "sys_catalog.sys_statio_all_tables"
sys_dump: reading indexes for table "sys_catalog.sys_statio_sys_indexes"
sys_dump: reading indexes for table "sys_catalog.sys_statio_sys_sequences"
sys_dump: reading indexes for table "sys_catalog.sys_statio_sys_tables"
sys_dump: reading indexes for table "sys_catalog.sys_statio_user_indexes"
sys_dump: reading indexes for table "sys_catalog.sys_statio_user_sequences"
sys_dump: reading indexes for table "sys_catalog.sys_statio_user_tables"
sys_dump: reading indexes for table "sys_catalog.sys_stats"
sys_dump: reading indexes for table "sys_catalog.sys_stats_ext"
sys_dump: reading indexes for table "sys_catalog.sys_tables"
sys_dump: reading indexes for table "sys_catalog.sys_timezone_abbrevs"
sys_dump: reading indexes for table "sys_catalog.sys_timezone_names"
sys_dump: reading indexes for table "sys_catalog.sys_user"
sys_dump: reading indexes for table "sys_catalog.sys_users"
sys_dump: reading indexes for table "sys_catalog.sys_user_mappings"
sys_dump: reading indexes for table "sys_catalog.sys_views"
sys_dump: reading indexes for table "pg_catalog.recyclebin"
sys_dump: reading indexes for table "pg_catalog.user_any_privs"
sys_dump: reading indexes for table "pg_catalog.sys_resource_groups"
sys_dump: reading indexes for table "pg_catalog.sys_resgroup"
sys_dump: reading indexes for table "sys.dual"
sys_dump: reading indexes for table "sys.user_objects"
sys_dump: reading indexes for table "sys.all_objects"
sys_dump: reading indexes for table "sys.user_types"
sys_dump: reading indexes for table "sys.all_types"
sys_dump: reading indexes for table "sys.user_tables"
sys_dump: reading indexes for table "sys.all_tables"
sys_dump: reading indexes for table "sys.user_all_tables"
sys_dump: reading indexes for table "sys.all_all_tables"
sys_dump: reading indexes for table "sys.user_col_privs"
sys_dump: reading indexes for table "sys.all_col_privs"
sys_dump: reading indexes for table "sys.ALL_CONSTRAINTS"
sys_dump: reading indexes for table "sys.user_constraints"
sys_dump: reading indexes for table "sys.all_tab_cols"
sys_dump: reading indexes for table "sys.user_tab_cols"
sys_dump: reading indexes for table "sys.user_table_cols"
sys_dump: reading indexes for table "sys.USER_INDEXES"
sys_dump: reading indexes for table "sys.ALL_INDEXES"
sys_dump: reading indexes for table "sys.user_tab_columns"
sys_dump: reading indexes for table "sys.all_tab_columns"
sys_dump: reading indexes for table "sys.all_ind_columns"
sys_dump: reading indexes for table "sys.user_ind_columns"
sys_dump: reading indexes for table "sys.user_views"
sys_dump: reading indexes for table "sys.all_views"
sys_dump: reading indexes for table "sys.all_sequences"
sys_dump: reading indexes for table "sys.user_sequences"
sys_dump: reading indexes for table "sys.all_triggers"
sys_dump: reading indexes for table "sys.user_triggers"
sys_dump: reading indexes for table "sys.all_source"
sys_dump: reading indexes for table "sys.user_source"
sys_dump: reading indexes for table "sys.user_tablespace"
sys_dump: reading indexes for table "sys.user_tablespaces"
sys_dump: reading indexes for table "sys.all_users"
sys_dump: reading indexes for table "sys.user_users"
sys_dump: reading indexes for table "sys.all_tab_privs"
sys_dump: reading indexes for table "sys.user_tab_privs"
sys_dump: reading indexes for table "sys.all_cons_columns"
sys_dump: reading indexes for table "sys.user_cons_columns"
sys_dump: reading indexes for table "sys.user_role_privs"
sys_dump: reading indexes for table "sys.all_tab_comments"
sys_dump: reading indexes for table "sys.user_tab_comments"
sys_dump: reading indexes for table "sys.all_col_comments"
sys_dump: reading indexes for table "sys.user_col_comments"
"