Received: from mail.memeticsystems.com (flywheel.memeticsystems.com
	[64.85.80.85])
	by postgresql.org (8.11.3/8.11.4) with SMTP id g0AMR7B50574
	for <pgsql-admin@postgresql.org>; Thu, 10 Jan 2002 17:27:07 -0500 (EST)
	(envelope-from peter@memeticsystems.com)
Received: (qmail 14717 invoked from network); 10 Jan 2002 22:27:08 -0000
Received: from unknown (HELO PETER) (63.249.24.21)
	by flywheel.memeticsystems.com with SMTP; 10 Jan 2002 22:27:08 -0000
From: "Peter T. Brown" <peter@memeticsystems.com>
To: <pgsql-admin@postgresql.org>, <pgsql-sql@postgresql.org>
Subject: replication
Date: Thu, 10 Jan 2002 14:27:07 -0800
Message-ID: <001101c19a25$f08ceec0$7d00000a@PETER>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
In-Reply-To: <22447.1010695481@sss.pgh.pa.us>
X-Archive-Number: 200201/56
X-Sequence-Number: 2944

Hello

I want to add replication capabilities to my postgresql installation. Can
anyone recommend a good way (open source or otherwise) to do so?

Basically, I have a web tracking application that must quickly and reliably
store massive amounts of tracking data. Later, I run complex queries to
analyze this tracking data. These complex queries tend to be very resource
intensive, so I'd like to have them run on a separate machine altogether. I
need a simple and reliable method to 'copy' any data added to the tracking
database to the analysis database. Preferably, I'd be able to configure this
copy process to defer to high priority queries or to be considerate of the
time of day.

Thanks,

Peter T. Brown