一、需求描述
金仓V8 R6数据库,需要编写自动备份shell脚本。
二、需要手动输入密码的备份脚本文件
#!/bin/bashexport 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/expectset password "Szzfaky@mgt123"log_file data/backup/expect_log.txtset timeout 600spawn date +"%Y%m%d_%H%M%S"expect -re "(.*)\n"set DATE $expect_out(1,string)regsub "\r" $DATE "" DATEset 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 testexpect "Password:"send "$password\r"expect eof

root@host-192-168-66-18 backup]# ./9.shspawn 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 testPassword:sys_dump: last built-in OID is 16383sys_dump: reading extensionssys_dump: identifying extension memberssys_dump: reading schemassys_dump: reading user-defined tablessys_dump: reading user-defined functionssys_dump: reading user-defined typessys_dump: reading procedural languagessys_dump: reading user-defined aggregate functionssys_dump: reading user-defined operatorssys_dump: reading user-defined access methodssys_dump: reading user-defined operator classessys_dump: reading user-defined operator familiessys_dump: reading user-defined text search parserssys_dump: reading user-defined text search templatessys_dump: reading user-defined text search dictionariessys_dump: reading user-defined text search configurationssys_dump: reading user-defined foreign-data wrapperssys_dump: reading user-defined foreign serverssys_dump: reading default privilegessys_dump: reading user-defined collationssys_dump: reading user-defined conversionssys_dump: reading type castssys_dump: reading transformssys_dump: reading table inheritance informationsys_dump: reading event triggerssys_dump: finding extension tablessys_dump: finding inheritance relationshipssys_dump: reading user tables which applied policysys_dump: reading column info for interesting tablessys_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 subtablessys_dump: reading indexessys_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"

"
文章转载自巴韭特锁螺丝,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




