检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Audit and Logs Audit Cloud Trace Service (CTS) CTS is a log audit service intended for cloud security. It records operations on the cloud resources in your account.
Figure 1 Setting SQL audit To disable SQL audit, toggle off the Audit Logging switch, select the confirmation check box, and click OK. After SQL audit is disabled, all audit logs will be deleted immediately and cannot be recovered.
Figure 1 TaurusDB for PostgreSQL audit logs Table 1 Audit log field description Field Description AUDIT: Fixed prefix, which identifies an audit record. AUDIT_TYPE Audit type. The value can be SESSION, OBJECT, or CLIENT_AUTHENTICATION.
The TaurusDB for PostgreSQL backup space stores automated backups, manual backups, and SQL audit logs. Automated full and incremental backups Automated backups cannot be manually deleted. To delete them, you can adjust the retention period specified in your backup policy.
Backup space Backup space is used to store automated backups, manual backups, and SQL audit logs. You can get a free backup space of the same size as your purchased storage space. If the free backup space is used up, the additional space will be billed.
Check for misoperations: If SQL auditing has been enabled, view data execution records in audit logs. Restore data using backup files: Use the TaurusDB for PostgreSQL restoration function. Import the backup data from the ECS to TaurusDB for PostgreSQL.
Unsupported Object Types The following object types are not supported: COLUMN MASTER KEY CREATE, ALTER EXTERNAL DATA SOURCE CREATE, ALTER, DROP DATABASE AUDIT SPECIFICATION CREATE, ALTER, DROP EXTERNAL LIBRARY CREATE, ALTER, DROP SERVER AUDIT CREATE, ALTER, DROP SERVER AUDIT SPECIFICATION
Security Shared Responsibilities Identity Authentication and Access Control Data Protection Audit and Logs Fault Recovery Certificates
reduces table bloat. pg_stat_statements Records SQL execution statistics for performance analysis. pg_trgm Provides triplet-based fuzzy text search and similarity calculation. pg_visibility Checks the visibility map of a table to optimize VACUUM. pgAudit Provides detailed database audit
log function gaussdb:auditlog:operate N/A Obtaining an audit log list gaussdb:auditlog:list N/A Querying the audit log policy gaussdb:auditlog:list N/A Obtaining the link for downloading an audit log gaussdb:auditlog:download N/A Obtaining a switchover log gaussdb:log:list N/A Creating
In the displayed dialog box, toggle on the audit log switch and set the number of days to retain audit logs. Figure 1 Setting SQL audit Configure parameters.
Log Management Viewing and Downloading Error Logs Viewing and Downloading Slow Query Logs Enabling SQL Audit Downloading SQL Audit Logs
