Is it possible to run multiple postgresql DB servers using duplicate, sync'd data? For scalability and fault tolerance in our web environment we want to have the database available on multiple servers. Each (or more than one, anyway) would have its own copy of the database, and they would need to stay relatively in sync with each other. We're not doing anything that critically needs instant, exact sameness of databases. It's okay if the databases lag each other's changes by, say, 5 minutes. Anyone done this? Is it a supported feature? Or would it have to be implemented carefully through triggers and exchanging log files or something like that? thanks, Michael
