Thread: PgBouncer with many databases
Is it possible to use PgBouncer in this scenario: User comes to my WA, and opens new account. In that case I create a new database for that user. I noticed that in PgBouncer config file I have to set a database line, so I'm confused Is there any way to deal with this problem? Just to say it in another way: Is there a way to dynamically add database to PgBouncer 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.
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