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
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 |