CODEWITHSUNDEEP
postgresqlconnection-poolingpgbouncer
nikhil raj
nikhil raj

Reputation: 65

How to install multiple PG Bouncers in single servers with different pool_mode

How can we Install multiple PG bouncer with different pool mode on a single server(Ubuntu18.04)?

when I tried to second time install it says already installed?

Is there any other way to install with a different port?

Upvotes: 0

Views: 1083

Answers (1)

antaxify
antaxify

Reputation: 342

You could install a container rungime (eg. docker) and run multiple containers, each containing a pgbouncer installation, eg. using this image: https://github.com/edoburu/docker-pgbouncer

First, install docker:

sudo apt install docker.io

Then, start can start as many pgbouncers as you like.

pgbouncer-1:

sudo docker run --rm -d \
    -n pgbouncer-session\
    -e DATABASE_URL="postgres://user:pass@postgres-host/database" \
    -e POOL_MODE=session \
    -p 5432:5432
    edoburu/pgbouncer

pgbouncer-2

sudo docker run --rm -d \
-n pgbouncer-transaction \
-e DATABASE_URL="postgres://user:pass@postgres-host/database" \
-e POOL_MODE=transaction \
-p 5433:5432
edoburu/pgbouncer

Note that the the containers use different ports on the host (first one uses 5432, second one uses 5433).

If you have lots of configuration, you might want to use a bind-mount for the configuration files.

Also, for a steady setup, I would recommend using docker-compose instead of raw docker commands.

Upvotes: 1

Related Questions