From: | Bo Peng <pengbo(at)sraoss(dot)co(dot)jp> |
---|---|
To: | Vasu Madhineni <vasumdba1515(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: HA setup with pg pool in docker |
Date: | 2020-07-23 15:55:04 |
Message-ID: | 20200724005504.d69e8782b62e5c39c071a212@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
On Wed, 22 Jul 2020 13:29:31 +0800
Vasu Madhineni <vasumdba1515(at)gmail(dot)com> wrote:
> We are planning to build a HA setup with pgpool in docker, Could you please
> let us know prerequisites for it.
>
> 1. How many servers are needed for this?, can we plan with 2 servers like
> below config.
> Primary instance and pgpool in two different docker containers in server
> 1 and standby instance in docker container server 2.
It depends on your requirements.
You can create 3 containers (pgpool, primary and standby)
on one server or on different servers.
> 2. User requirement: any user needs password less authentication between
> nodes.
It is possible by configuring pool_hba.conf (Pgpool-II) and pg_hba.conf (PostgreSQL).
> 3. Port or firewall rules between servers.
Pgpool port and PostgreSQL port need to be accessible.
> 4. If planning to create a network bridge between all docker containers
> between 2 servers will be any prerequisites for that.
You need to make sure all containers can connect to each other.
--
Bo Peng <pengbo(at)sraoss(dot)co(dot)jp>
SRA OSS, Inc. Japan
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Peng | 2020-07-23 16:07:20 | Re: Pgpool in docker container |
Previous Message | David G. Johnston | 2020-07-23 15:05:17 | Re: Problem with pg_service.conf |