Re: mirroring databases

Thank you for that suggestion.

What is the general method for replacing changed records and adding new
records, between remote locations? Assume a one-way sync, ie a mirror.
Records will only be added or changed at one location.

Thank you,

- April


At 11:52 AM 7/17/2002 -0500, D. Duccini wrote:
>
>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!"   
>-----------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>