| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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!"
-----------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aarni Ruuhimäki / Megative Tmi / KYMI.com | 2002-07-18 21:29:04 | Re: Newbie Stupid Question |
| Previous Message | Josh Berkus | 2002-07-18 17:33:41 | Re: special accents in text columns |