Re: PGbouncer and batch vs real-time pools

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема Re: PGbouncer and batch vs real-time pools
Дата
Msg-id CAL_0b1v7dnw8gV52XRr-2DA9bcQt5RsJHGS4CM7Pu_uxbTbMaA@mail.gmail.com
обсуждение исходный текст
Ответ на PGbouncer and batch vs real-time pools  (François Beausoleil <francois@teksol.info>)
Список pgsql-general
On Thu, Feb 14, 2013 at 9:09 AM, Fran=E7ois Beausoleil
<francois@teksol.info> wrote:
> I believe the important user is the one pgbouncer uses to connect to the =
real PostgreSQL server. That user + dbname is what creates a new pool. The =
client's name (the one the app connects as) is irrelevant since I hard-code=
 what user I want to use.
>
> Did I read the configuration manual right? Any advice from people "famili=
ar with the matter"?

Yes, you understand it right. It all the connections between pgbouncer
and postgres will be done with the user you specified in the
configuration file does not mater what user you used to connect to
pgbouncer from your application. And yes it means that you will have
these two pools only.

--=20
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 по дате отправления:

Предыдущее
От: Jack Christensen
Дата:
Сообщение: Re: Avoiding duplication of code via views -- slower? How do people typically do this?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Howto see template objects in PGAdmin3