From adey11@gmail.com Thu Jul 6 04:57:26 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 756349FB1C3 for ; Thu, 6 Jul 2006 01:57:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 78150-03 for ; Thu, 6 Jul 2006 01:57:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 5BE4C9FB1C0 for ; Thu, 6 Jul 2006 01:57:22 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so2533055ugf for ; Wed, 05 Jul 2006 21:57:20 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=PS82zb9bzmR9fHhzvwZ9RRWA8eUrU+cjRHIW40id8EIZ7JQp730W8g5I3W/gIjmwM521fmfKLvgJhXilsLc2nAHAg2Z8ztJ1Kp8A1+JeSPgwTftsyC3CxPI1OgJObjJnlo07zvXDeUTf5g175AhLrVKVKsE9ISMPEhLSnqQhjU8= Received: by 10.67.101.10 with SMTP id d10mr219064ugm; Wed, 05 Jul 2006 21:57:20 -0700 (PDT) Received: by 10.66.234.17 with HTTP; Wed, 5 Jul 2006 21:57:20 -0700 (PDT) Message-ID: <1c66bda80607052157m51c61e81x4e5f2774dfa1300a@mail.gmail.com> Date: Thu, 6 Jul 2006 16:57:20 +1200 From: adey To: "pgsql-admin@postgresql.org" , postgresql-l Subject: pgpool MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16979_26485281.1152161840555" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/31 X-Sequence-Number: 22277 ------=_Part_16979_26485281.1152161840555 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Please could someone give me an idea of what pgpool is, and where I can research it? I have run a search on postgresql.org and found many references, but they don't explain what it is, and it doesn't appear in the documentation index of the v8.1 manuals. ------=_Part_16979_26485281.1152161840555 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Please could someone give me an idea of what pgpool is, and where I can research it?
I have run a search on postgresql.org and found many references, but they don't explain what it is, and it doesn't appear in the documentation index of the v8.1 manuals.
------=_Part_16979_26485281.1152161840555-- From gbarosio@gmail.com Thu Jul 6 12:13:59 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A7D6F9FA147 for ; Thu, 6 Jul 2006 09:13:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07686-05 for ; Thu, 6 Jul 2006 09:13:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id E075E9FA0EC for ; Thu, 6 Jul 2006 09:13:53 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id g2so145528nfe for ; Thu, 06 Jul 2006 05:13:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=P5ppRTqwvyxhv9LdzuPgGDLPYcZynv8bCyc6E5z0QFQ8pSp+VEteLDYAadJkpTgYnF5n6oKLs49hvsL+RtGNjfNVSmRlUDmGCK9ZWvx/rUoHL9pEl7NgZLogU+KzmEfwYrCubFgUBDzY5bRj7SDEGakXDqBycEz0ZL2mMLmocpQ= Received: by 10.78.177.3 with SMTP id z3mr175146hue; Thu, 06 Jul 2006 05:13:51 -0700 (PDT) Received: by 10.78.177.14 with HTTP; Thu, 6 Jul 2006 05:13:51 -0700 (PDT) Message-ID: Date: Thu, 6 Jul 2006 09:13:51 -0300 From: "Guido Barosio" To: adey Subject: Re: pgpool Cc: "pgsql-admin@postgresql.org" , postgresql-l In-Reply-To: <1c66bda80607052157m51c61e81x4e5f2774dfa1300a@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1c66bda80607052157m51c61e81x4e5f2774dfa1300a@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/33 X-Sequence-Number: 22279 http://pgpool.projects.postgresql.org/ from the site: "What is pgpool? pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can connect to pgpool as if it were a standard PostgreSQL server..." G.- On 7/6/06, adey wrote: > > Please could someone give me an idea of what pgpool is, and where I can > research it? > I have run a search on postgresql.org and found many references, but they > don't explain what it is, and it doesn't appear in the documentation index > of the v8.1 manuals. -- Guido Barosio ----------------------- http://www.globant.com guido.barosio@globant.com From cbbrowne@acm.org Thu Jul 6 12:48:11 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EFF109FA43C for ; Thu, 6 Jul 2006 09:48:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07659-07 for ; Thu, 6 Jul 2006 09:48:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 66E999FA0EC for ; Thu, 6 Jul 2006 09:48:08 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k66Cm0wg051079 for ; Thu, 6 Jul 2006 09:48:00 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k66CiPkh050190 for pgsql-admin@postgresql.org; Thu, 6 Jul 2006 09:44:25 -0300 (ADT) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: pgpool Date: Thu, 06 Jul 2006 08:42:17 -0400 Organization: cbbrowne Computing Inc Lines: 31 Message-ID: <87lkr6x5ue.fsf@wolfe.cbbrowne.com> References: <1c66bda80607052157m51c61e81x4e5f2774dfa1300a@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:DMJUNFKUz9IQ0+p7bpV+sJbMA4c= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/36 X-Sequence-Number: 22282 After a long battle with technology, adey11@gmail.com (adey), an earthling, wrote: > Please could someone give me an idea of what pgpool is, and where I can research it? > > I have run a search on postgresql.org and found many references, but > they don't explain what it is, and it doesn't appear in the > documentation index of the v8.1 manuals. It's not officially part of the database, so no, it's not in the database documentation. It's a connection pool server implemented in C... The notion is that you run your database on (say) port 5432, and then put pgpool in between, on port 4432. pgpool opens up some fixed number of connections to the database, keeping them open, and your application connects to port 4432, as if it were a direct connection to the database. pgpool then manages the connections, basically keeping them open irrespective of how your application handles connections. This can be a big help to performance if your application is pretty loose about opening and closing connections whenever it likes. -- (reverse (concatenate 'string "moc.liamg" "@" "enworbbc")) http://linuxdatabases.info/info/lsf.html The real problem with the the year 2000 is that there are too many zero bits and that adversely affects the global bit density. -- Boyd Roberts From karuna.karpe@os3infotech.com Fri Sep 23 07:13:05 2011 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C76D7B5DC09 for ; Fri, 23 Sep 2011 04:13:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 82949-05 for ; Fri, 23 Sep 2011 07:12:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-qy0-f174.google.com (mail-qy0-f174.google.com [209.85.216.174]) by mail.postgresql.org (Postfix) with ESMTP id D4C95B5DC01 for ; Fri, 23 Sep 2011 04:12:54 -0300 (ADT) Received: by qyk30 with SMTP id 30so6885787qyk.19 for ; Fri, 23 Sep 2011 00:12:54 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.27.137 with SMTP id i9mr2424886qcc.251.1316761974174; Fri, 23 Sep 2011 00:12:54 -0700 (PDT) Received: by 10.229.183.84 with HTTP; Fri, 23 Sep 2011 00:12:54 -0700 (PDT) Date: Fri, 23 Sep 2011 12:42:54 +0530 Message-ID: Subject: pgpool From: Karuna Karpe To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001636426c11b9727e04ad9689fc X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201109/165 X-Sequence-Number: 38402 --001636426c11b9727e04ad9689fc Content-Type: text/plain; charset=ISO-8859-1 Hello, I am run pgpool and then create database bench. After that I run following command : pgbench -i -p 9999 bench But I got following error : 2011-09-23 12:38:11 ERROR: pid 12697: pool_read_kind: kind does not match between master(53) slot[1] (45) 2011-09-23 12:38:11 ERROR: pid 12697: pool_do_auth: failed to read kind before BackendKeyData Connection to database "bench" failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. what can do for remove this error? please give me solution for that? Regards, karuna karpe. --001636426c11b9727e04ad9689fc Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello,

=A0=A0=A0=A0=A0=A0=A0 I am run pgpool and then create databas= e bench.=A0 After that I run following command :

pgbench -i -p 9999 = bench

But I got following error :

2011-09-23 12:38:11 ERROR: = pid 12697: pool_read_kind: kind does not match between master(53) slot[1] (= 45)
2011-09-23 12:38:11 ERROR: pid 12697: pool_do_auth: failed to read kind bef= ore BackendKeyData
Connection to database "bench" failed:
s= erver closed the connection unexpectedly
=A0=A0=A0 This probably means t= he server terminated abnormally
=A0=A0=A0 before or while processing the request.

what can do for re= move this error? please give me solution for that?

Regards,
karun= a karpe.
--001636426c11b9727e04ad9689fc-- From arvind.chikne@gmail.com Mon Oct 29 19:17:51 2018 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 1gHD3E-0002hq-6M for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:18:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHD3C-0003UR-2z for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:18:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHD3B-0003UJ-PE for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:18:09 +0000 Received: from mail-lj1-x229.google.com ([2a00:1450:4864:20::229]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gHD39-0006M8-31 for pgsql-admin@postgresql.org; Mon, 29 Oct 2018 19:18:08 +0000 Received: by mail-lj1-x229.google.com with SMTP id k11-v6so8968499lja.5 for ; Mon, 29 Oct 2018 12:18:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=vY4+oUyAt3BNGpQIgMhLXp9yyonGc9qrhgEkt5wqLDE=; b=hoec9ENHEOv19qgeql+6XFRfEsmR+d2tf642LjA93i3EFzZy3drITMItKAJMe7KB2p D7WP8LLUTLNVQVqFkTgLsSjGctY4KqIW0RAFfumLWKtlDpLOo0T4+QHlhi/j/jVhVCFa uJxCXFKz0hVLMi2D62VCXQA3omo5Op+OEJNTWAiCHMSgMUiS3VQ+2DOOh64Kkow/UD7W ml7SRKpLw3I3m8TFtRfF9J3DwKcPvCatxgAYa1HTNezoK8Qq+Ak3njaGPvwz7C932gel Gj9F6GDS0IYi2gHXGx7ZhkkX1QB5G8eg9+kpmh19mCX/MCSFNU39kXJGgDeHe0bq/85Y 23xw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=vY4+oUyAt3BNGpQIgMhLXp9yyonGc9qrhgEkt5wqLDE=; b=OKfm1cujJ0i982yI5JE2ScmRH5HiyVjJ2ogUBEoW0Rc4c+v6E/74LM9PWRkuvXNKlO 8e9b0jIeH/UaGYUqVZLhSX49M5O6gD/PtBdSdEVnkXJ7t6BEhigzWqm4OTKhwL8f1eh7 qj66nWSmB3nXyUDVFQvOQrgVMJOTvJQAkLQTwwAbhcvHBxYViPq6TJRQ8S2a+h0OcGYP ERltDJ1mlz0R0qjI5krCPmmVUW4e0ZIkQLgqWIVAwF3dK15Mjh5QBZL3JYTY716wrNbs xv70T48SBETyuQaARN2HO/fycw5L/5e09VJtujiPsNTKRJL2pJV6ypNz7a1dxtMIDo4Q w5jQ== X-Gm-Message-State: AGRZ1gJqAzA72+HksgRX3FDIxMK4U1DtLgsjwiN85mU7qQNHHoNsQHwv uMn8b8akbFjifneGkSKYjim/77ifHcl1TDP681UqUCu7 X-Google-Smtp-Source: AJdET5e/GOwf0DP9DTwUpB6cERG8JsYzdgdn8UGNgGsb6eVJjwgZkXrf4VoSB4ZHl38E0XASDbKXQ7jhVSyupPi+E8o= X-Received: by 2002:a2e:5816:: with SMTP id m22-v6mr6901574ljb.177.1540840684664; Mon, 29 Oct 2018 12:18:04 -0700 (PDT) MIME-Version: 1.0 From: arvind chikne Date: Tue, 30 Oct 2018 00:47:51 +0530 Message-ID: Subject: pgpool To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000aa3d0a057962ed79" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000aa3d0a057962ed79 Content-Type: text/plain; charset="UTF-8" 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 --000000000000aa3d0a057962ed79 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Can any one suggest how to install pgpool....???

<= /div>
=C2=A0

--
<= div>Thanks & Regards=
Arvind rao chikne
9818979986
= Think Green!!!=C2=A0Please= =C2=A0cons= ider=C2=A0your = environmental responsibility before printing this e-mail

=
--000000000000aa3d0a057962ed79-- From abalashov@evaristesys.com Mon Oct 29 19:21:28 2018 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 1gHD6u-0002s7-UF for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:22:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHD6s-00010W-Ke for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:21:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHD6W-0007ds-BW for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:21:36 +0000 Received: from allegro-1.evaristesys.com ([209.51.167.66] helo=evaristesys.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHD6R-0006Sn-R7 for pgsql-admin@postgresql.org; Mon, 29 Oct 2018 19:21:35 +0000 Received: from [208.71.233.170] (helo=tlaquepaque.localdomain) by evaristesys.com with esmtpsa (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.89) (envelope-from ) id 1gHD6P-0000rY-QG for pgsql-admin@postgresql.org; Mon, 29 Oct 2018 15:21:29 -0400 Date: Mon, 29 Oct 2018 15:21:28 -0400 From: Alex Balashov To: pgsql-admin@postgresql.org Subject: Re: pgpool Message-ID: <20181029192128.GA12896@tlaquepaque.localdomain> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Organization: Evariste Systems User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 -- Alex Balashov | Principal | Evariste Systems LLC Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ From arvind.chikne@gmail.com Mon Oct 29 19:31:38 2018 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 1gHDGY-0003L4-2U for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:31:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHDGW-0002tT-CB for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:31:56 +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 1gHDGV-0002tM-Ua for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:31:56 +0000 Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gHDGS-0001jY-QR for pgsql-admin@postgresql.org; Mon, 29 Oct 2018 19:31:54 +0000 Received: by mail-lf1-x129.google.com with SMTP id m18-v6so6978884lfl.11 for ; Mon, 29 Oct 2018 12:31:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=01UK2O0ir9KQG7fO6kKWYzc0w3GjTuqexDe9niY1Yps=; b=mW5G15WR4o+v3T6i2VWEi8EcCAyZrh1TBHhDCTxDNZuy7FaPs26w/Pv4it7prJL8FC 4kDA2beIMG8lY/QbFt+0jvMc3Wdt0SxzbxcGA2pwieKNcz+00bLQ50U5obumVDOaXWno a1OOkNBOW9+7zC+tu1kA79emRb4Tx/lcEQq8l4OLpsBXfb80ZEXjrjFNrX2pOphVVOTT htTbxiaAhcUiFE8ZITHDQusl2oEXNzEcj8ULdlZiVh7L0vMKw9KDKvHhng2Na1VcATcv kCNwvZ5drgodvVMVT7FG5jESK2GSdtM3lRn1qM+0Jh0UPYNxuukJFrog7OG5i7JsER5k ruqw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=01UK2O0ir9KQG7fO6kKWYzc0w3GjTuqexDe9niY1Yps=; b=TuvUISq6NS21Yv87BqS+HEw3WOasytgav6LX7raR3sW7jqZYQ8hQY/Feuy7XLLDeJO 3tAKpLv8KmeYTOPJ3yujWzM34WNIQED9/bmH8rmQO51rWr2MeuykRMQNQFQIhCiU4w3c PqdRHClihhMT4TrMvwfdSYfIqLn5WVq3Zyj0j95AS5V1Ut5Sl3aqY1EjUkmEQPZXZoGC tMBdeyGzhoNaQEgHPFjg3uktXN8iFFMGct+w4LVVtW2icUjJHzd+x4pJie4BVKqnudD2 zb8REY1VeefJz2pY+YcInU/4z7kA7SRxq5uPVsu0F9yxXm3a9QQrmRCzBoPvf6LTQYmf cOvQ== X-Gm-Message-State: AGRZ1gKV40pbDcbLhGDNf5tBsGD2tZtJboSiebFkt4uDeoY0+sVhT6Tr HsAf+FjTsqKabncDFxMwLjJ6FTppsG/frZc8BIz41vR/ X-Google-Smtp-Source: AJdET5eno5uW8We1QfqE7l5/MYJ5wYdfCslST8UfKtX83AxOLsYdrhTt42ANkWw3BkSNjH+JmWXsHPexiUAmNAJpvlg= X-Received: by 2002:a19:d212:: with SMTP id j18-v6mr37879lfg.44.1540841510801; Mon, 29 Oct 2018 12:31:50 -0700 (PDT) MIME-Version: 1.0 References: <20181029192128.GA12896@tlaquepaque.localdomain> In-Reply-To: <20181029192128.GA12896@tlaquepaque.localdomain> From: arvind chikne Date: Tue, 30 Oct 2018 01:01:38 +0530 Message-ID: Subject: Re: pgpool To: abalashov@evaristesys.com Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000e819020579631e30" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000e819020579631e30 Content-Type: text/plain; charset="UTF-8" Thanks Alex, but can you suggest how to configure it. On Tue, Oct 30, 2018 at 12:52 AM Alex Balashov 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 > > -- > Alex Balashov | Principal | Evariste Systems LLC > > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) > Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ > > -- *Thanks & Regards* Arvind rao chikne 9818979986 *Think Green!!!* Please consider your environmental responsibility before printing this e-mail --000000000000e819020579631e30 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Alex, but can you suggest how to configure it.=C2= =A0

On Tue, Oct 30, 20= 18 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 bef= ore
> printing this e-mail

--
Alex Balashov | Principal | Evariste Systems LLC

Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/



--
Thanks & Rega= rds
Arvind rao chikne
9818979986
= Think Green!!!=C2=A0Ple= ase=C2=A0= c= onsider=C2=A0yo= ur environmental responsibility before printing this e-mail

--000000000000e819020579631e30-- From abalashov@evaristesys.com Mon Oct 29 19:37:46 2018 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 1gHDMP-0003ff-Ks for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:38:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHDMN-0002N9-Id for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:37:59 +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 1gHDMG-0001kX-D1 for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:37:52 +0000 Received: from allegro-1.evaristesys.com ([209.51.167.66] helo=evaristesys.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHDMC-0001rZ-R8 for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:37:50 +0000 Received: from [208.71.233.170] (helo=tlaquepaque.localdomain) by evaristesys.com with esmtpsa (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.89) (envelope-from ) id 1gHDMC-0000uB-1y for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 15:37:48 -0400 Date: Mon, 29 Oct 2018 15:37:46 -0400 From: Alex Balashov To: pgsql-admin@lists.postgresql.org Subject: Re: pgpool Message-ID: <20181029193746.GE12896@tlaquepaque.localdomain> References: <20181029192128.GA12896@tlaquepaque.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Organization: Evariste Systems User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 > 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 > > > > -- > > Alex Balashov | Principal | Evariste Systems LLC > > > > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) > > Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ > > > > > > -- > *Thanks & Regards* > Arvind rao chikne > 9818979986 > *Think Green!!!* Please consider your environmental responsibility before > printing this e-mail -- Alex Balashov | Principal | Evariste Systems LLC Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ From arvind.chikne@gmail.com Mon Oct 29 19:42:17 2018 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 1gHDQv-0003tQ-Nm for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:42:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHDQt-0000Kj-Qg for pgsql-admin@arkaria.postgresql.org; Mon, 29 Oct 2018 19:42:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHDQo-0008Fh-El for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:42:34 +0000 Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gHDQk-0006wk-R6 for pgsql-admin@lists.postgresql.org; Mon, 29 Oct 2018 19:42:33 +0000 Received: by mail-lf1-x129.google.com with SMTP id o2-v6so6994841lfl.13 for ; Mon, 29 Oct 2018 12:42:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=clxg1cCaDZlzuEpRK56TCt9jhmr86/8WVQq1qxgAWLs=; b=C4zh903xmUT6uMtAL47M/xUA2eTVzT+tWXqKJ4f8+OQUsCGrGsjr0mGAvP9wE1vKWx GRersKtYs7e4rXvONr4sob+57zzFQIxxc7bkGomw+9YWP4giv7n2tB525PXP3vksCgrW o+x6RdlzM7w3HTA5L9aN7nXBbo7tN24HvHOQf4mhwPf0KSRitowj1nCxTruZewpK1uQh tfnlwzjsuBDOSeIUiI/GjZa7xgE1Dao6vpuXoEP1DbGmyuqU9G6yfykZT34wQmz7C8cU T3CrTo8XrEs5fXBi3KTva5zp+lIEk3+ndDCM6+VDcCzaebgj/YShW3qyTSM/3RqEZhVY RSiw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=clxg1cCaDZlzuEpRK56TCt9jhmr86/8WVQq1qxgAWLs=; b=BPUNc/gaBEWrH+SIkwl6+Crg/FN2zPjFsduMdiCVEJrnomzcsLR2Aq4+iuV0KvVhf7 k4lZeTZbGMir3LDOZZaX6NNwJ9KBb3urejZD8KUYPYJeyhcsRlSRI+dmCFXMjeiBFcgQ wxc1hl4G4CDj/teMQljDFkBeFSKMsWY+pfbqUPWFFFo3WqsMx3WCc6VE1UsgC5WzzVDe P9JIu8sGBefquK6uj2MJaYxlq0pxpYa95BPb2sBbJrcGnFxPX4ehTsQkDZRgezWu37mu Qd98kvgTRizZRo3qpUfH9EtyBSHDuXWdvsrFY0mrrmLFepWk3uif0WM9L8I9j1DLQ/qj bzHg== X-Gm-Message-State: AGRZ1gJg7RDu9g1oLsBcnw/TXdgoFsMjQ4CN0Z6cwMhKicPGBADeXB9h wSxEEs6m291MSS2q88sf7eWtlC2NtDLjlA/mBo0= X-Google-Smtp-Source: AJdET5cEowIqvWo3R22A8jBloXE5F9/lC9Q9m+K2JxHZiR9nnJqQrEGdqz8j91iU4m1kebq2uOtdpsSqq24mDZAdDaQ= X-Received: by 2002:a19:59d3:: with SMTP id n202-v6mr32513lfb.125.1540842149913; Mon, 29 Oct 2018 12:42:29 -0700 (PDT) MIME-Version: 1.0 References: <20181029192128.GA12896@tlaquepaque.localdomain> <20181029193746.GE12896@tlaquepaque.localdomain> In-Reply-To: <20181029193746.GE12896@tlaquepaque.localdomain> From: arvind chikne Date: Tue, 30 Oct 2018 01:12:17 +0530 Message-ID: Subject: Re: pgpool To: abalashov@evaristesys.com Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000000293705796345b8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000000293705796345b8 Content-Type: text/plain; charset="UTF-8" I would like to configure it for Hot standby (Auto fail over ) 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 > > > > > > -- > > > Alex Balashov | Principal | Evariste Systems LLC > > > > > > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) > > > Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ > > > > > > > > > > -- > > *Thanks & Regards* > > Arvind rao chikne > > 9818979986 > > *Think Green!!!* Please consider your environmental responsibility before > > printing this e-mail > > -- > Alex Balashov | Principal | Evariste Systems LLC > > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) > Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ > > -- *Thanks & Regards* Arvind rao chikne 9818979986 *Think Green!!!* Please consider your environmental responsibility before printing this e-mail --00000000000000293705796345b8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I would like to configure it for Hot standby (Auto fail ov= er )

On Tue, Oct 30, 2= 018 at 1:08 AM Alex Balashov <abalashov@evaristesys.com> wrote:
There are many possible suggestions, depending on which of the man= ifold,
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&g= t;
> 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 responsi= bility before
> > > printing this e-mail
> >
> > --
> > Alex Balashov | Principal | Evariste Systems LLC
> >
> > Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
> > Web: http://www.evaristesys.com/, http://www.csrpswitch.co= m/
> >
> >
>
> --
> *Thanks & Regards*
> Arvind rao chikne
> 9818979986
> *Think Green!!!* Please consider your environmental responsibility bef= ore
> printing this e-mail

--
Alex Balashov | Principal | Evariste Systems LLC

Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/



--
Thanks & Rega= rds
Arvind rao chikne
9818979986
= Think Green!!!=C2=A0Ple= ase=C2=A0= c= onsider=C2=A0yo= ur environmental responsibility before printing this e-mail

--00000000000000293705796345b8-- From ioguix@free.fr Mon Oct 29 19:58:06 2018 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