DBS-C01 · Question #95
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional…
The correct answer is B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs. To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for…
Question
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs. What should the company do to address this space constraint issue?
Options
- ALog in to the host and run the rm $PGDATA/pg_logs/* command
- BModify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs
- CCreate a ticket with AWS Support to have the logs deleted
- DRun the SELECT rds_rotate_error_log() stored procedure to rotate the logs
How the community answered
(59 responses)- A7% (4)
- B88% (52)
- C2% (1)
- D3% (2)
Explanation
To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for one day. The default value is 4,320 (three days). The maximum value is 10,080 (seven days). https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.Concepts .PostgreSQL.html
Topics
Community Discussion
No community discussion yet for this question.