暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

国产化金仓V8 R6数据库:全库自动备份shell脚本生成dmp文件【测试成功】

巴韭特锁螺丝 2024-07-03
132

一、需求描述

    金仓V8 R6数据库,需要编写自动备份shell脚本。

二、需要手动输入密码的备份脚本文件

    #!/bin/bash


    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 "$password\r"


      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"

          "

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

          评论