Date: Fri, 21 Sep 2012 12:50:42 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=66.87.0.203;
	posting-account=lc_-4QoAAADAwaU3-alPZhalkZK-lSTn
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <aa705243-9e27-4e6a-a8e9-28b19adb1e47@googlegroups.com>
Subject: Multiple servers with Postgresql
From: John Coryat <coryat@gmail.com>
Injection-Date: Fri, 21 Sep 2012 19:50:42 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
To: pgsql-admin@postgresql.org

I have a number of web servers that access a server largely dedicated to ju=
st Postgres. There are over a million queries a day to this server. It's wo=
rking well and doesn't seem to be bogged down.

I would like to improve my server system by using a mirror or alternate mac=
hine 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 a=
mong separate servers?

Thanks in advance for any assistance.

-John Coryat