Using RSYNC for replication?

From: Jason Hihn <jhihn1(at)umbc(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Using RSYNC for replication?
Date: 2003-01-28 04:56:09
Message-ID: 3E360D69.6050208@umbc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A sequence of events ocurred to me today that left me wondering if I can
rsync the raw files as a form of replication. I'd like to keep
postmaster running, but flush and lock everything, then perform the copy
via rsync so only the new data is propigated, all while postmaster is
running.

In general, data is only added to a few tables in the database, with
updates occuring infrequently to the rest. Rarely are deletes ever done.
During the sync neither DB will change except as part of the rsync.

I think this would be a quick, dirty, safe and efficient way to
accomplish this without having to take down postmaster and send the
whole shebang over.

Are people using this? Will it work? Is it feasible? Thoughts?

Many thanks in advance,
-Jason

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Aufflick 2003-01-28 04:56:25 Re: all backends (pg7.2.3 / redhat 7.2) die due to unexpected signal 14 (SIGALRM)
Previous Message Gabriel Munteanu 2003-01-28 04:47:06 Re: migrating from progress dbms