Has anyone written a HSA e-commerce solution using postgres? In english, this means I want more than one server running postgres with the same database(s). I get lots and lots of queries, and it's just too much for one poor machine to handle. I get far less inserts, updates, and deletions, but regardless, the DB's have to be synchronized every couple hours. If I can't find any HSA to start from, then I'll start from scratch, but I thought I'd ask first. If I start from scratch, an initial architecture that comes to mind is designating one server as the master, and the others as slaves. Every slave gives the rows to be replicated (since the last replication) to the master at a configurable interval. When the master has been served by all the slaves, he then synchronizes everyone...I read somewhere that this is one of the advantages Oracle has over Postgres, but that in a year Postgres should have an HSA solution. Is anyone working on this? Maybe we could start? Thanks, Rich ************
