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-18 20:03:14
Message-ID: Pine.GSO.4.03.10207181500470.2150-100000@ra.bpsi.net (view raw or flat)
Thread:
Lists: pgsql-novice
> 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.

make a 'diff' kind of file based on the changed information -- you can
either send out the changes to a file to be processed remotely by a piece
of software, or you can create a dump kind of file for direct import 

of course you could also look at doing a file-level replication using
something like rsync 

-----------------------------------------------------------------------------
david(at)backpack(dot)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!"   
-----------------------------------------------------------------------------


In response to

pgsql-novice by date

Next:From: Aarni Ruuhimäki / Megative Tmi / KYMI.comDate: 2002-07-18 21:29:04
Subject: Re: Newbie Stupid Question
Previous:From: Josh BerkusDate: 2002-07-18 17:33:41
Subject: Re: special accents in text columns

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