I'm considering using a cloud hosting solution for my website. It will probably be either Amazon, Rackspace or Hosting.com. I'm still comparing. Either way, my site will consist of multiple virtual server instances that I can create and destroy as needed. Each virtual machine instance will be self contained, meaning it'll run the website and its own instance of postgres. The website will only talk to the local DB instance. However, if I'm running several machine instances, I want all the databases to keep in sync preferably with as little lag as possible. This is not a master/slave replication issue where there's one big DB that's always up and everything syncs to, this is basically total peer-to-peer replication where any time data is updated on one server, an update command gets sent to all the other servers. I would also have to address the issue when I provision a new virtual server, I'd have to import the current data into the DB seamlessly. What's the best way to do this? Looks like something like pgPool might be what I want, but I haven't looked into it deeply yet. Thanks!! Mike -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
