Horton

Re: mirroring databases

D. Duccini <duccini@backpack.com>

View thread View on postgr.es
From: "D. Duccini" <duccini@backpack.com>
To: April L <april@i-netco.com>
Cc: pgsql-novice@postgresql.org
Date: 2002-07-17T16:52:54Z
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?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 


-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.    
+1 651.645.9798 fax            Don't forget your BackPack!"   
-----------------------------------------------------------------------------