Anoop Bhat <ABhat at trustwave.com> writes:
> I've got a server with two databases on it. What's the best way to replicate them?
>
> A single cluster with multiple databases (I'm not sure how I would do this, any sample scripts out there?)
>
> Or
>
> Two clusters replicating one database each.
>
> I ask this question because I've setup two clusters already replicating one database each to a single slave server and I'm getting this error message
>
>    remoteWorkerThread_1: transactions earlier than XID 3916431719 are still in progress
>    remoteWorkerThread_1: data copy for set 1 failed - sleep 60 seconds
>
> I'm wondering what the better option is.

I'm not sure about "better option"; this situation has been described
in the FAQ for a long time now:

   <http://www.slony.info/documentation/faq.html#AEN5630>
-- 
output = ("cbbrowne" "@" "cbbrowne.com")
http://linuxfinances.info/info/slony.html
You know better than to trust a strange computer.