I have a number of web servers that access a server largely dedicated to just Postgres. There are over a million queries a day to this server. It's working well and doesn't seem to be bogged down.
I would like to improve my server system by using a mirror or alternate machine for both backup and serving queries. The problem is the data has to be up to date on both machines. I've been using Postgres for many years but I've never had to do anything like this before.
What are the best practices for doing this type of data and query sharing among separate servers?
Thanks in advance for any assistance.
-John Coryat