Thread: Azure Database for PostgreSQL - how to add pgbouncer or similar?
Good morning,
in Microsoft Azure how to add pgbouncer or a similar software enabling multiple simultaneous connections?
After reading https://docs.microsoft.com/en-us/azure/postgresql/overview I could not find such options...
Thank you
Alex
On 6/29/19 12:34 AM, Alexander Farber wrote: > Good morning, > > in Microsoft Azure how to add pgbouncer or a similar software enabling > multiple simultaneous connections? Not from within. Supported extensions: https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions Using search term 'azure postgresql connection pooler', a sample blog that shows another way: https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions Why not spin up a VM and install your own Postgres ? > > After reading > https://docs.microsoft.com/en-us/azure/postgresql/overview I could not > find such options... > > Thank you > Alex -- Adrian Klaver adrian.klaver@aklaver.com
Thank you Adrian -
On Sat, Jun 29, 2019 at 3:59 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/29/19 12:34 AM, Alexander Farber wrote:
Not from within. Supported extensions:
https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions
Using search term 'azure postgresql connection pooler', a sample blog
that shows another way:
https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions
Why not spin up a VM and install your own Postgres ?
I am just overwhelmed by the Azure, too many options there...
You are correct - I could easily create a Linux VM and install Postgres and pgbouncer there :-)
But how to create the "cloudliness" then? I.e. how to automatically launch additional VM instances automatically when the load is increasing? (and still keep the database "in sync")
Regards
Alex
On 6/29/19 8:33 AM, Alexander Farber wrote: > Thank you Adrian - > > On Sat, Jun 29, 2019 at 3:59 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > On 6/29/19 12:34 AM, Alexander Farber wrote: > > Not from within. Supported extensions: > > https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions > > Using search term 'azure postgresql connection pooler', a sample blog > that shows another way: > > https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions > > > Why not spin up a VM and install your own Postgres ? > > > I am just overwhelmed by the Azure, too many options there... > > You are correct - I could easily create a Linux VM and install Postgres > and pgbouncer there :-) > > But how to create the "cloudliness" then? I.e. how to automatically > launch additional VM instances automatically when the load is > increasing? (and still keep the database "in sync") Will need more information about what it is you are trying to achieve and what Azure options you are considering? > > Regards > Alex > -- Adrian Klaver adrian.klaver@aklaver.com