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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
