Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHDgH-0004bk-V0 for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:58:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHDgF-0001GE-5h for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:58:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHDgE-0001G7-PN for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:58:30 +0000 Received: from smtp5-g21.free.fr ([2a01:e0c:1:1599::14]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHDg7-0002Jq-Jg for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:58:29 +0000 Received: from firost (unknown [90.38.160.95]) (Authenticated sender: ioguix) by smtp5-g21.free.fr (Postfix) with ESMTPSA id 6D6B85FFC3; Mon, 29 Oct 2018 20:58:13 +0100 (CET) Date: Mon, 29 Oct 2018 20:58:06 +0100 From: "Jehan-Guillaume (ioguix) de Rorthais" To: arvind chikne Cc: abalashov@evaristesys.com, pgsql-admin@lists.postgresql.org Subject: Re: pgpool Message-ID: <20181029205806.5f78b821@firost> In-Reply-To: References: <20181029192128.GA12896@tlaquepaque.localdomain> <20181029193746.GE12896@tlaquepaque.localdomain> X-Mailer: Claws Mail 3.17.1 (GTK+ 2.24.32; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, 30 Oct 2018 01:12:17 +0530 arvind chikne wrote: > I would like to configure it for Hot standby (Auto fail over ) Unless you have really good reasons, I would not recommend pgpool for auto failover. Pick another existing project. It might be more or less difficult to setup, depending on your setup and constraints though. HA is a long process to have something clean and useful. Take as much time to implement it as your data deserve. > On Tue, Oct 30, 2018 at 1:08 AM Alex Balashov > wrote: > > > There are many possible suggestions, depending on which of the manifold, > > expansive array of things that can be done with it you seek to > > accomplish. > > > > On Tue, Oct 30, 2018 at 01:01:38AM +0530, arvind chikne wrote: > > > > > Thanks Alex, but can you suggest how to configure it. > > > > > > On Tue, Oct 30, 2018 at 12:52 AM Alex Balashov < > > abalashov@evaristesys.com> > > > wrote: > > > > > > > Not merely suggest, but extensively intimate: > > > > > > > > # yum -y install postgresql-pgpool-II > > > > > > > > On Tue, Oct 30, 2018 at 12:47:51AM +0530, arvind chikne wrote: > > > > > > > > > Can any one suggest how to install pgpool....??? > > > > > > > > > > > > > > > > > > > > -- > > > > > *Thanks & Regards* > > > > > Arvind rao chikne > > > > > 9818979986 > > > > > *Think Green!!!* Please consider your environmental responsibility > > before > > > > > printing this e-mail