Re: mirroring databases - Mailing list pgsql-novice

From Henshall, Stuart - WCP
Subject Re: mirroring databases
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F74928@MAIL_EXCHANGE
Whole thread Raw
In response to mirroring databases  (April L <april@i-netco.com>)
List pgsql-novice

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

pgsql-novice by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Seeding
Next
From: "Derek Barrett"
Date:
Subject: Headcount: Anyone successfully using PHP/Postgres/AOLServer in production?