agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Peter T. Brown <peter@memeticsystems.com>
To: pgsql-admin@postgresql.org
To: pgsql-sql@postgresql.org
Subject: replication
Date: Thu, 10 Jan 2002 14:27:07 -0800
Message-ID: <001101c19a25$f08ceec0$7d00000a@PETER> (raw)
In-Reply-To: <22447.1010695481@sss.pgh.pa.us>

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

view thread (10+ messages)  latest in thread

Message-ID: <001101c19a25$f08ceec0$7d00000a@PETER>
Permalink:  ../001101c19a25$f08ceec0$7d00000a@PETER/
Also on:    postgresql.org/message-id/001101c19a25$f08ceec0$7d00000a@PETER

reply

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-sql@postgresql.org
  Cc: peter@memeticsystems.com, pgsql-admin@postgresql.org
  Subject: Re: replication
  In-Reply-To: <001101c19a25$f08ceec0$7d00000a@PETER>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox