Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdM5v-0007dt-PB for pgsql-admin@arkaria.postgresql.org; Thu, 12 Nov 2020 23:33:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kdM5t-0000m7-0e for pgsql-admin@arkaria.postgresql.org; Thu, 12 Nov 2020 23:33:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdM5s-0000ly-PI for pgsql-admin@lists.postgresql.org; Thu, 12 Nov 2020 23:33:32 +0000 Received: from mout.perfora.net ([74.208.4.197]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdM5l-00068g-Tk for pgsql-admin@postgresql.org; Thu, 12 Nov 2020 23:33:32 +0000 Received: from [192.168.1.165] ([72.205.30.64]) by mrelay.perfora.net (mreueus004 [74.208.5.2]) with ESMTPSA (Nemesis) id 1MNtKu-1kx6wD3IwS-00OJZg; Fri, 13 Nov 2020 00:33:21 +0100 Subject: Re: Pgpool for Pooling and Load Balancing To: Walters Che Ndoh Cc: pgsql-admin@postgresql.org References: From: MichaelDBA Message-ID: Date: Thu, 12 Nov 2020 18:33:18 -0500 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.36 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Provags-ID: V03:K1:qvXoI7HZFmKTqsHmoD51zBUr6KQmHLF+qKwZNlAvtPdGWS6ILPi LTXTUqCN7I1KkLdOtYTYmHoV1so9D/kt1shwY9l6cWvjNPip3tL94czZcmK/0R9I/l5Um0+ 9fPS9yrR3WTRaWs0hjevTTezIrq/7ExolMxjo0FPIbqEgayeymQoi5KaknyYsc6+nCZJu00 8HakKgYDGi4U9lZjNcp9A== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:5gqkUwoF8DY=:gaMdOooHLAtSV6tM7Z7ISW 2C4Rnt/oFlogXkp8wkgdYRSWPMb7fGkOpWOrHqAMPFyDJGXQPMTRE1n3XtnjcrDw4XTQV5u8A m4Fo3ihuHnUS1P30N6o76pvQBIVIP5B28j4YyOczAkddZZzR0el6Raxl7glx6bctC3krs1TNe F6vufZ4cgFNJAL6my6g4mzbTq756koj16lo0yS0tVwEZE1vb9z/6lr7Tr5Fr7TgGoMlQVXI7+ CnpZOaObFZP1SXqOatqEoXK/zgoYnI3711pzplck4T4tgUOXIQwm5LWgmqH+WSbKNiTdJnXM6 6fD7fsKnAhR3VZ31rKulPYfepi9Ha/YDlBqIBwMlXST2Uyz5hk+8g/svKDKhXyreDzwqA2Aiq 9SZ2jwCWYx0cmOYMsUg6P6H2EIiKNn8wEwC8UqpRzazZTejiPygAgzwre5XaDMZPeu11dt/EL 3G4N2aVaSQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Walters, You said, "...to get help here on each step as I go along." That's what usually happens when you hire someone to setup a HA environment for ya.  It might be better served for you and us to ask specific questions as you go along. Thanks for the picture.  I'm a bit confused by it.  Is pgpool2 and postres installed on server A and B respectfully?  If so that is a normal setup, and the one I'm most familiar with. Regards, Michael Vitale Walters Che Ndoh wrote on 11/12/2020 6:09 PM: > to get help here on each step as I go along.