I am developing an application using Postgresql, where database availability is critical. Can someone suggest some open source/paid solution which can handle below
- Automatic backups, such that I can schedule backups on hourly/daily basis.
- Master slave configuration or anything similar, so that when my main db goes down, still the db requests can be handled by slave/secondary server.
- Load balancing - In future I may need load balance the read-write queries.