检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Solution: Encrypt the password. GAUSS-00576: "Must be system admin to create replication users." SQLSTATE: 42501 Description: You have no permission to create replication users. Solution: Create replication users as a system administrator.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 CREATE TEXT SEARCH DICTIONARY norwegian_ispell ( TEMPLATE = ispell, DictFile = nn_no, AffFile = nn_no, FilePath = 'obs://bucket01/obs.example.com
Hash functions md5(string) Use MD5 to encrypt string and return a hexadecimal value.
', SECRET_ACCESS_KEY 'secret_access_key_value_to_be_replaced', encrypt 'on', type 'obs' ); Mandatory parameters are described as follows: Name of the foreign server You can customize a name.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 ALTER TEXT SEARCH DICTIONARY my_dict (StopWords = newrussian, FilePath = 'obs://bucket_name/path accesskey=ak secretkey=sk region=rg' ); Change the Language setting
', SECRET_ACCESS_KEY 'secret_access_key_value_to_be_replaced', encrypt 'on', type 'obs' ); Mandatory parameters are described as follows: Name of the foreign server You can customize a name.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 CREATE TEXT SEARCH DICTIONARY thesaurus_astro ( TEMPLATE = thesaurus, DictFile = thesaurus_astro, Dictionary = pg_catalog.english_stem, FILEPATH
Figure 14 Setting data sources Select the GaussDB(DWS) connection information, click Edit Permissions, deselect Encrypt connections, and click OK. Figure 15 Switching to a non-encrypted connection Close the window for setting the data source.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 DROP TEXT SEARCH DICTIONARY IF EXISTS english_ispell; CREATE TEXT SEARCH DICTIONARY english_ispell ( TEMPLATE = ispell, DictFile = english,
See Table 1 for application scenarios and Data Export By a User Without Required Permissions for operation details. gs_dump and gs_dumpall encrypt the exported data files. These files are decrypted before being imported to prevent data disclosure for higher database security.
10.10.10.100 -g gs_dumpall[port=''][2018-11-14 19:06:24]: dumpall operation successful gs_dumpall[port=''][2018-11-14 19:06:24]: total time: 1150 ms Example 2: Use gs_dumpall to run the following command as the cluster administrator dbadmin to export global tablespaces in a cluster, encrypt
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 CREATE TEXT SEARCH DICTIONARY pg_dict ( TEMPLATE = synonym, SYNONYMS = pg_dict, FILEPATH = 'obs://bucket01/obs.example.com accesskey=xxxxx secretkey
Table 7 Data encryption information Parameter Description Key Name Indicates the database encryption key of the cluster when Encrypt DataStore is enabled. Last Key Rotation Time Indicates the time when the last encryption key is rotated when Encrypt DataStore is enabled.
- Enable SSL If Enable SSL is selected, the client can use SSL to encrypt connections. The SSL mode is more secure than common modes, so you are advised to enable SSL connection. - When Enable SSL is selected, download and decompress the SSL certificate.
***:9000', type'HDFS'); CREATE SERVER obs_server FOREIGN DATA WRAPPER dfs_fdw OPTIONS ( address 'obs.ap-southeast-1.myhuaweicloud.com' , ACCESS_KEY 'access_key_value_to_be_replaced', SECRET_ACCESS_KEY 'secret_access_key_value_to_be_replaced', encrypt 'on',
- Enable SSL If Enable SSL is selected, the client can use SSL to encrypt connections.
The \i+, \ir+, and \include_relative+ meta-commands and the input and output parameter -k are added to encrypt imported and exported files. Historical command lines cannot be printed to files using the \s meta-command.
The \i+, \ir+, and \include_relative+ meta-commands and the input and output parameter -k are added to encrypt imported and exported files. Historical command lines cannot be printed to files using the \s meta-command.
For security purposes, encrypt your AK and SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 SELECT * FROM ts_debug('english', 'Paris');
backup/MPPDB_backup.sql -p 8000 -h 10.10.10.100 -s gs_dumpall[port=''][2018-11-14 11:28:14]: dumpall operation successful gs_dumpall[port=''][2018-11-14 11:28:14]: total time: 4147 ms Example 3: Use gs_dumpall to run the following command export data of all databases in a cluster, encrypt
