| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Jason Hihn <jhihn1(at)umbc(dot)edu>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using RSYNC for replication? |
| Date: | 2003-01-28 06:09:42 |
| Message-ID: | 5.1.0.14.1.20030128140818.02cc5d00@mbox.jaring.my |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
What about existing open transactions during the sync?
Link.
At 11:56 PM 1/27/03 -0500, Jason Hihn wrote:
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sector119 | 2003-01-28 06:46:29 | Re: tsearch comments |
| Previous Message | Christopher Kings-Lynne | 2003-01-28 06:05:22 | Re: Using RSYNC for replication? |