Synchronization is the one area that postgres has traditionally trailed mysql, but I know I have seen presentations on sync tools (but have not used them) for postgres including:
www.slony.info http://eradman.com/posts/pgsql-sync.html There was another promising project whose name I can't now recall, and Google isn't presently helping. Perhaps after some sleep. -- Matt Warnock <mwarn...@ridgecrestherbals.com> RidgeCrest Herbals, Inc. On Fri, 2010-08-13 at 11:08 +0530, Raj Saini wrote: > > Since you're strongly suggesting Postgres, do you have any advice for > > migrating a live system between databases, hopefully from an Entity > > perspective? > > > May be export/import of the data in entity-engine-xml help the > migration. You do not need to deal with the DMBS specific queries and > OFBiz already handles the table creation using entity models. > > Thanks, > > Raj >