Re: HA setup with pg pool in docker - Mailing list pgsql-general

From Bo Peng
Subject Re: HA setup with pg pool in docker
Date
Msg-id 20200724005504.d69e8782b62e5c39c071a212@sraoss.co.jp
Whole thread Raw
In response to HA setup with pg pool in docker  (Vasu Madhineni <vasumdba1515@gmail.com>)
List pgsql-general
Hello,

On Wed, 22 Jul 2020 13:29:31 +0800
Vasu Madhineni <vasumdba1515@gmail.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@sraoss.co.jp>
SRA OSS, Inc. Japan



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Problem with pg_service.conf
Next
From: Bo Peng
Date:
Subject: Re: Pgpool in docker container