Hello Benjamin, On Wed, 2010-08-18 at 16:32 -0700, Benjamin Smith wrote: > Is there a way to update a number of databases hosted on a single server > without opening a separate psql connection to each database? I believe you are more interested in applying an atomic update for all databases rather than specifically the problem of separate psql connections to each database. Is that correct ? > This way we can be sure that either all the databases are in synch, or that we > need to rollback the program patch/update. > simultaneous connections, is there a way to run all the transactions for a > single server for all databases within it on a single (or small number) of > connections? It would be easy to extend the ChronicDB live database schema update system to support an atomic schema change across a multitude of databases. > Is there a better way? ChronicDB replicates a database to use a new schema in the background. When the schema change completes and few incremental changes remain, active transactions are temporarily paused and then rerouted to the new schema. This currently works for a schema change of a single database, but the parallel update you are requesting could be supported. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
