Skip site navigation (1) Skip section navigation (2)

Re: mirroring databases

From: "D(dot) Duccini" <duccini(at)backpack(dot)com>
To: April L <april(at)i-netco(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: mirroring databases
Date: 2002-07-17 16:52:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
put a trigger on the table so that it updates a date/timestamp on updates,
like a "lastModified" column

On Wed, 17 Jul 2002, April L wrote:

> Has anyone done, or know of utilities for, remote location "near real time
> mirroring" of postgres databases?
> An update every 15 minutes or so would work for this purpose. However, the
> total number of records is in the millions, and the number of changed or
> new records per day could be thousands.
> To avoid transferring all records, I'm imagining a flag column that
> indicates if a new or changed record has been transferred to the mirror yet.
> Any suggestions...? 
> - April
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?

david(at)backpack(dot)com            BackPack Software, Inc.
+1 651.645.7550 voice       "Life is an Adventure.    
+1 651.645.9798 fax            Don't forget your BackPack!"   

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2002-07-17 17:24:48
Subject: Re: Help: Dumb newbie locked himself out!
Previous:From: Balazs WellischDate: 2002-07-17 16:51:01
Subject: Help: Dumb newbie locked himself out!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group