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