Re: PgBouncer with many databases - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: PgBouncer with many databases
Date
Msg-id CAL_0b1s-tTJNNxjUNzEx0K60pdOSFvsMVCc9_nB_fnEujm1ZNA@mail.gmail.com
Whole thread Raw
In response to PgBouncer with many databases  (komunca <komunca@gmail.com>)
List pgsql-general
On Mon, Feb 18, 2013 at 3:59 PM, komunca <komunca@gmail.com> wrote:
> Just to say it in another way: Is there a way to dynamically add database to
> PgBouncer

Yes it is possible to do. You need to add the following to the
[databases] section in your pgbouncer config file.

* = host=localhost

From the pgbouncer documentation
http://pgbouncer.projects.pgfoundry.org/doc/config.html:

"*" acts as fallback database: if the exact name does not exist, its
value is taken as connect string for requested database.

>
>
> Thanks
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/PgBouncer-with-many-databases-tp5745729.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp

Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

Skype: gray-hemp
Jabber: gray.ru@gmail.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL took over my login
Next
From: Jeff Janes
Date:
Subject: Re: Perl function leading to out of memory error