Here is the filesystem method using rsync.
I haven't used this method myself.
http://www.taygeta.com/ha-postgresql.html
----- Original Message -----
From: "D. Duccini" <duccini@backpack.com>
Date: Thu, 18 Jul 2002 15:03:14 -0500 (CDT)
To: April L <april@i-netco.com>
Subject: Re: [NOVICE] mirroring databases
>
> > 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@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 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
--
_______________________________________________
Get your free email from http://www.graffiti.net
Powered by Outblaze