You’ll need to have discourse use the primary. When it fails you’d use dns or haproxy to switch to the secondary.
This isn’t a Discourse issue. If you want to learn how to manage redis and postgres I’m a high availability setup, you’ll need to search elsewhere.