agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Bryan White <bryan@arcamax.com>
To: pgsql-admin@postgresql.org
Subject: Re: [SQL] replication
Date: Thu, 10 Jan 2002 18:34:13 -0500
Message-ID: <011701c19a2f$4f843790$2ed260d1@bryan> (raw)
References: <001101c19a25$f08ceec0$7d00000a@PETER>

> 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.

How closely does the replicated data have to track your live data.  I my
installation I have an cron job that runs at 2:30am daily.  It backs up the
database (using pg_dump) and loads it on another machine.  I can then run
queries the next day on the backup machine without hurting performance on
the primary.  It also has the side effect of producing the backup file for
saving to tape or whatever.  It also veryfies daily that the backup file is
not corrupt because the load would fail on the secondary machine.

This is not true replication but it might serve your needs.  I looked at the
replication solutions for PostgreSQL a while ago and got the impression they
were not ready for primetime.  In may have changed since then.

view thread (10+ messages)  latest in thread

Message-ID: <011701c19a2f$4f843790$2ed260d1@bryan>
Permalink:  ../011701c19a2f$4f843790$2ed260d1@bryan/
Also on:    postgresql.org/message-id/011701c19a2f$4f843790$2ed260d1@bryan

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: bryan@arcamax.com, pgsql-admin@postgresql.org
  Subject: Re: [SQL] replication
  In-Reply-To: <011701c19a2f$4f843790$2ed260d1@bryan>

* 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