Which solution will meet these requirements?

By:
On:
In: DBS-C01
Tagged:
With: 0 Comments
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance.The company recently conducted tests on the database after business hours, and the tests generated additional database logs.As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.The company wants to recover the free storage that the additional logs consumed.The solution must not result in downtime for the database.

Which solution will meet these requirements?

Modify the rds.log_retention_period parameter to 0. Reboot the DB instance to save the changes.

Modify the rds.log_retention_period parameter to 1440. Wait up to 24 hours for database logs to be deleted.

Modify the temp_file_limit parameter to a smaller value to reclaim space on the DB instance.

Modify the rds.log_retention_period parameter to 1440. Reboot the DB instance to save the changes.

Explanations:

Modifying therds.log_retention_periodparameter to 0 would delete logs, but this change requires a DB instance reboot, which would result in downtime. The requirement specifies no downtime.

Modifying therds.log_retention_periodparameter to 1440 (24 hours) allows logs to be deleted after a period, freeing up space. This change does not require a reboot and does not result in downtime.

Modifying thetemp_file_limitparameter impacts temporary file usage, but it doesn’t directly address reclaiming storage used by database logs. This change wouldn’t help recover the consumed storage from the logs.

Modifying therds.log_retention_periodparameter to 1440 and rebooting the instance would cause downtime, which violates the requirement for no downtime. The log retention change can occur without a reboot.

Leave a Reply

Your email address will not be published. Required fields are marked *

twenty − 9 =