Are these 5 databases on different servers and at different locations or
are they on the same local cluster?
If they are all on the same local cluster you may want to rethink how you
are storing customer data. The design you describe seems redundant.
If you are dealing with multiple servers (and
Having all the dblink destinations on the same server makes it a much more
viable option since the chances of the dblink update failing are greatly
reduced. That said, here's a run down on the queue system I described with
some specificity toward your situation.
You can add a flag to each custome