Re: postgres java driver, can I connect to a server instead of a database?

On Thu, Aug 21, 2014 at 1:34 AM, S Ahmed <sahmed1020(at)gmail(dot)com> wrote:

> Hello,
>
> In a Saas application that has 1 database per customer, you may have
> thousands of customers and therefore thousands of databases.
>
> Creating thousands of connection pools is very costly memory wise.
>
> What options are there with the postgres java driver currently?
>
> Say I have 1 server with 500 customer databases on it.
> Can I somehow create 1 connection pool to the server, and then switch to
> the correct database on a per query basis? Or does the driver not support
> this?
>
> Or maybe this isn't a driver specific issue but rather a connection pool
> question?
>

If the database per customer design can be modified, please have a look at
http://www.postgresql.org/docs/current/static/ddl-schemas.html