Deleting a PostgreSQL database instance

Sometimes, you might want to remove a piece of software and, in doing so, also remove the unused database from your AWS account. You can delete a PostgreSQL RDS that does not have deletion protection enabled. When we created or modified our PostgreSQL RDS in the previous sections, there was an option to enable deletion protection so that the RDS cannot be deleted. Perform the following steps:

1. Click on Databases from the navigation tabs on the left-hand side. Then, select the atm database to enable the Actions menu, as shown in the following screenshot:

Figure 2.29 – Enabling the Actions menu on the atm database

2. Check the drop-down menu for Actions and select the Delete option, as shown in the following screenshot:

Figure 2.30 – The Actions > Delete option to remove the atm database

3. Enter delete me to confirm the deletion, as shown in the following screenshot. Then, click on ...