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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to