From: John Coryat <coryat@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Multiple servers with Postgresql
Date: Fri, 21 Sep 2012 12:50:42 -0700 (PDT)
Message-ID: <aa705243-9e27-4e6a-a8e9-28b19adb1e47@googlegroups.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: coryat@gmail.com
Subject: Re: Multiple servers with Postgresql
In-Reply-To: <aa705243-9e27-4e6a-a8e9-28b19adb1e47@googlegroups.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox