My short answer: Yes, but... My long answer: After years of experience with highly-available database provision with PostgreSQL, I concluded that I don't want

My short answer: Yes, but... My long answer: After years of experience with highly-available database provision with PostgreSQL, I concluded that I don't want automatic failover. It's more practical to keep a master running and constantly replicated by slaves that can be promoted to master in migration or failure situation. However, when there is a failure situation it's so exceptional that someone really needs to understand what happened before allowing the next victim (er, database) to go on stage.