cloudwatch alarm when aurora postgres failover event occurs

Question

Hello,

I'd like to get a cloudwatch alert setup when a failover event occurs. Does anyone know what I should be looking for in the postgresql.log or what cloudwatch metric I can use for this?

Thanks in advance!

Jeremy

Accepted Answer

It is better to use RDS event notification instead of CloudWatch.  
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_Events.html

Settings can be made in the following documentation methods.  
When setting up the system, select failover in the "Specific event categories" to be notified when a failover occurs.  
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_Events.Subscribing.html  
![db](/media/postImages/original/IMV9t16UHNRomPso45mYy8IA)

Answer

Hi,

Please take a look at this [Well Architected Lab](https://catalog.us-east-1.prod.workshops.aws/workshops/098605dc-8eee-4e84-85e9-c5c6c9e43de2/en-US/lab8-fault-tolerance/event), this will surely help you out in setting up notification mechanism for Aurora Postgres failover events.

Answer

Thank you both! I had no idea about event notifications like this. This is SO much better than figuring out how to do this via cloudwatch.

cloudwatch alarm when aurora postgres failover event occurs

Relevant content