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@postgresql.org
>