Re: mirroring databases

Interesting reading about rsync and heartbeat.

Now I understand the suggestion that I could dump the changed and new
records to a file, send them to the remote location perhaps with rsync,
then "import" them.

Luckily this is the novice list, so I can ask things like:

could I just do a select into (or whatever means "append new and replace
existing") statement at the remote location that accessed the changed/new
records at the other location? would that be a lot slower or have other
disadvantages?

Thank you,

- April

At 10:09 AM 7/19/2002 +0800, Derek Barrett wrote:
>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>