Re: Massively Parallel transactioning?

On Aug 18, 2010, at 4:32 PM, 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? 
> 
> We have a cluster of servers hosting an application on Postgres. Right now, we 
> have dozens of databases per server, enough that we're starting to have 
> problems with our update process. 
> 

Any reason you're using multiple databases, rather than multiple schemas?

> Is there a better way?

Schemas, probably. Though lazy schema updates done by the application might help too.

Cheers,
  Steve