Is rserv suitable for what you want?
I believe that provides single master async replication (not 100% sure as I havn't used it).
- Stuart
> -----Original Message-----
> From: April L [mailto:april@i-netco.com]
> Sent: 17 July 2002 18:30
> To: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] 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
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
