Re: Fast Table Replication / Mirroring

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Alex <alex(at)meerkatsoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Fast Table Replication / Mirroring
Date: 2003-08-29 03:59:30
Message-ID: 20030829005853.M30178@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 29 Aug 2003, Alex wrote:

> Hi,
> I saw some replication projects but think this might be an overkill for
> my intentions.
>
> I have two databases, Primary / Secondary where the Secondary is
> readyonly for
> users. I need to mirror tables when changes occur on that table. That
> may happen a few times a day.
> Tables are in the area of few 100k records.
>
> A) Is there an easy way to copy the data from Primary to Secondary
> Can this be triggered by updates on the primary table ?

We're actually using eRServer inhouse for this, to keep "local copies" of
on specific table in sync between several servers ...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-29 04:06:56 Re: Problems with transactions and sequences
Previous Message Matthew T. O'Connor 2003-08-29 03:58:46 Re: Vacuuming and already vacuumed table?