Re: PgBouncer with many databases

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: komunca <komunca(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: PgBouncer with many databases
Date: 2013-02-21 00:02:04
Message-ID: CAL_0b1s-tTJNNxjUNzEx0K60pdOSFvsMVCc9_nB_fnEujm1ZNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 18, 2013 at 3:59 PM, komunca <komunca(at)gmail(dot)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(at)postgresql(dot)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(dot)ru(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-02-21 00:02:58 Re: Perl function leading to out of memory error
Previous Message Adrian Klaver 2013-02-20 23:42:40 Re: PostgreSQL took over my login