[Tfug] synchronizing databases (postgres)

[Chad Woolley]

I know replication is built into commercial DBs like oracle, and I
have worked on products like this for commercial dbs.  However, I
don't know much about postgres. I would search for "postgres
replication", maybe that will give some hits.  Or look up Oracle's
terminology for it, and google for similar terms + postrgres.

Failing that, you could take an incremental backup strategy, if
postgres support that.  I mean to take a full backup of the current DB
(which presumably can be done while the db is online).  Then, restore
that backup to the new db.  Then, take the old db down, do an
incremental backup from the time of the full backup (which should be
faster), then restore that incremental backup to the new server.
Might not work, but an idea...

-- chad



On 8/30/06, Jeremy C. Reed <reed at reedmedia.net> wrote:
> Can anyone point me to some docs or suggest some ideas or tools (like perl
> modules or scripts) for synchronizing postgres databases?
>
> I will be migrating data from one server to another but may take several
> days. I am researching to see if I can keep the existing server up and
> available. And after the migration just turn the user interface off and do
> a quicker "sync" of the two databases to complete the migration. (With the
> hope that the downtime will be less than a couple hours instead of couple
> days.)
>
> Any advice would be appreciated.
>
> Jeremy C. Reed
>
> _______________________________________________
> Tucson Free Unix Group - tfug at tfug.org
> Subscription Options:
> http://www.tfug.org/mailman/listinfo/tfug_tfug.org
>