Re: Fast Table Replication / Mirroring - Mailing list pgsql-general

From Marc G. Fournier
Subject Re: Fast Table Replication / Mirroring
Date
Msg-id 20030829005853.M30178@ganymede.hub.org
Whole thread Raw
In response to Fast Table Replication / Mirroring  (Alex <alex@meerkatsoft.com>)
List 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 ...


pgsql-general by date:

Previous
From: Sander Smeenk
Date:
Subject: Re: PostgreSQL upgrade -> fails to start server
Next
From: david_shadovitz@xontech.com (David Shadovitz)
Date:
Subject: Re: CHAR vs TEXT args