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
