检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
SQLSTATE: XX000 Description: MD5 fails to encrypt passwords. Solution: Contact technical support. Parent topic: GAUSS-00601 -- GAUSS-00700
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
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' ); Modify the Language parameter
', 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
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 \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');
In 8.0.0, this parameter is supported only in 8.0.0.10 or later. encrypt Specifies whether data is encrypted. This parameter is available only when type is OBS. The default value is off.
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.
In 8.0.0, this parameter is supported only in 8.0.0.10 or later. encrypt Specifies whether data is encrypted. This parameter is available only when type is OBS. The default value is off.
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
For security, encrypt your AK/SK and store them in the configuration file or environment variables. 1 2 3 4 5 6 7 8 9 CREATE SERVER obs_servevr FOREIGN DATA WRAPPER DFS_FDW OPTIONS ( address 'obs.example.com:5443', //Address for accessing OBS encrypt 'on', access_key '{AK value}
OPTIONS ( { option_name ' value ' } [, ...] ) Specifies parameters of foreign table data. encrypt Specifies whether HTTPS is enabled for data transfer. on enables HTTPS and off disables it (in this case, HTTP is used).
***: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',
