From pierre.ochsenbein@acceleris.ch Tue Jun 5 15:18:40 2018 Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQDjX-0000p7-0B for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 15:18:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQDjV-0007zO-SC for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 15:18:49 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQDjV-0007zF-HI for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 15:18:49 +0000 Received: from smtp.kmu4u.ch ([213.221.202.48]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQDjQ-00005n-Np for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 15:18:47 +0000 X-Virus-Scanned: Debian amavisd-new at smtp.kmu4u.ch X-Spam-Flag: NO X-Spam-Score: -0.272 X-Spam-Level: X-Spam-Status: No, score=-0.272 required=4 tests=[BAYES_00=-1.9, HTML_IMAGE_ONLY_24=1.618, HTML_MESSAGE=0.001, NO_RECEIVED=-0.001, NO_RELAYS=-0.001, T_REMOTE_IMAGE=0.01, URIBL_BLOCKED=0.001] autolearn=disabled From: Pierre Ochsenbein To: "pgsql-admin@lists.postgresql.org" Subject: pgpool-II with PostgreSQL Streaming replication Thread-Topic: pgpool-II with PostgreSQL Streaming replication Thread-Index: AQHT/N9fN1ye/I5AY06r54Lm8iz3mA== Date: Tue, 5 Jun 2018 15:18:40 +0000 Message-ID: <1528211920098.8069@acceleris.ch> Accept-Language: fr-FR, en-US, de-CH Content-Language: fr-FR x-ms-exchange-transport-fromentityheader: Hosted Content-Type: multipart/alternative; boundary="_000_15282119200988069accelerisch_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_15282119200988069accelerisch_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear all, How to build pgpool-II with a PostgreSQL Streaming replication? Where I can find a documentation? Thanks a lot. Pierre [Acceleris] Acceleris AG | cloudifying IT Pierre Ochsenbein | Technical Consultant Schosshaldenstrasse 85 | CH-3006 Bern T : +41 31 911 33 22 | F : +41 31 911 62 63 pierre.ochsenbein@acceleris.ch | www.acceleris.ch Acceleris Offices are in : Bern | Zurich | Renens | Bucharest [Acceleris] Disclaimer This message possibly contains confidential data or items of information. I= t is intended solely for the rightful recipient. If you should have receive= d the message wrongfully, it is not permitted to disclose the e-mail messag= e or its contents to third parties, to copy or use it. We would respectfull= y request you to destroy the message with the exclusion of any reproduction= and to notify this to the originator by e-mail. Thank you very much. --_000_15282119200988069accelerisch_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear all,


How to build pgpool-II with a PostgreSQL Streaming replication?

Where I can find a documentation?


Thanks a lot.


Pierre


3D"Acceleris"

Accele= ris AG | cloudifying IT
Pierre Ochsenbein | Technical Consultant
Schosshaldenstrasse 85 | CH-3006 Bern
T : +41 31 911 33 22 | F : +41 31 911 62 63
pierre.ochsenbein@acceleris.ch | www.acceleris.ch  

Acceleris Offices are in :
Bern | Zurich | Renens | Bucharest
 
3D"Acceleris"
 

Disclaimer

This message possibly contains confidential data or items of information. I= t is intended solely for the rightful recipient. If you should have receive= d the message wrongfully, it is not permitted to disclose the e-mail messag= e or its contents to third parties, to copy or use it. We would respectfully request you to destroy the messag= e with the exclusion of any reproduction and to notify this to the originat= or by e-mail. Thank you very much.





--_000_15282119200988069accelerisch_-- From gilberto.castillo@etecsa.cu Tue Jun 5 15:26:47 2018 Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQDsv-0001Yu-Ck for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 15:28:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQDsr-0005qx-VL for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 15:28:29 +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 1fQDrJ-0000M2-PC for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 15:26:53 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQDrG-0002VX-Ne for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 15:26:52 +0000 Received: from mail.etecsa.cu (unknown [192.168.91.10]) by imx6.etecsa.cu (Postfix) with ESMTP id BFF0AAC; Tue, 5 Jun 2018 11:26:47 -0400 (CDT) Received: from webmailrc.etecsa.cu (unknown [192.168.97.37]) (Authenticated sender: gilberto.castillo) by mail.etecsa.cu (Postfix) with ESMTPA id 8AF113294446; Tue, 5 Jun 2018 11:26:47 -0400 (CDT) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Date: Tue, 05 Jun 2018 11:26:47 -0400 From: gilberto.castillo@etecsa.cu To: Pierre Ochsenbein Cc: pgsql-admin@lists.postgresql.org Subject: Re: [MASSMAIL]pgpool-II with PostgreSQL Streaming replication In-Reply-To: <1528211920098.8069@acceleris.ch> References: <1528211920098.8069@acceleris.ch> Message-ID: X-Sender: gilberto.castillo@etecsa.cu User-Agent: Roundcube Webmail/1.2.5 X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 125538 [Jun 05 2018] X-KLMS-AntiSpam-Version: 5.8.1.0 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 136 136 c82d77b5fe5df28ce564602406d3c21afb9c8b73, Auth:dkim=none, DmarcAF: none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2018/05/25 10:21:04 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2018/06/05 08:26:00 #8584512 X-KLMS-AntiVirus-Status: Clean, skipped List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Uhmmm, I think load my note about this topic. El 2018-06-05 11:18, Pierre Ochsenbein escribió: > Dear all, > > How to build pgpool-II with a PostgreSQL Streaming replication? > > Where I can find a documentation? > > Thanks a lot. > > Pierre > > Acceleris AG | cloudifying IT > Pierre Ochsenbein | Technical Consultant > Schosshaldenstrasse 85 | CH-3006 Bern > T : +41 31 911 33 22 | F : +41 31 911 62 63 > pierre.ochsenbein@acceleris.ch | www.acceleris.ch > > Acceleris Offices are in : > Bern | Zurich | Renens | Bucharest > > Disclaimer > This message possibly contains confidential data or items of > information. It is intended solely for the rightful recipient. If you > should have received the message wrongfully, it is not permitted to > disclose the e-mail message or its contents to third parties, to copy > or use it. We would respectfully request you to destroy the message > with the exclusion of any reproduction and to notify this to the > originator by e-mail. Thank you very much. From shreeyansh2014@gmail.com Tue Jun 5 15:28:25 2018 Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQDsv-0001Yt-Ck for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 15:28:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQDsr-0005qy-VQ for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 15:28:29 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQDsr-0005qY-Hh for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 15:28:29 +0000 Received: from mail-yb0-x22a.google.com ([2607:f8b0:4002:c09::22a]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fQDso-0000MA-JY for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 15:28:28 +0000 Received: by mail-yb0-x22a.google.com with SMTP id p22-v6so905504yba.13 for ; Tue, 05 Jun 2018 08:28:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=ELQAjq4DbssI5SKbU9MC7g8tekQ/wfGrMy9pMdHwoR0=; b=kGo8cCsTUkoaSMqwTdBA89eLnd7NHQ4HEQXx5JDFgnjS5P9fkwdiFkqqtqXO6IfQFu Ij83hnYV3v+QXiroCIdlpbK4HkInexgQO7lGJH/qfqnGvbJd3YoqbO7iidh71c3Ea0Km DIt+VCSd+R302K2hb7MsJrcWsT/dxH1OS/Plp+mS7U2QBv0cqvezKzaKp6hAXOwYmN8+ NLZd5x2z0T5XpyMGBzkY8TMgZPMEgcFXJ6OzwfXfH5MAsf2sEBikalP9wtIb9aA0Yq70 fNizJ2bJM1cfuJePPtmHCzL91IaEBjHGeh2pAvArJ547v7hUMFyEQPs1q+ubyEReFUtF z6gQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=ELQAjq4DbssI5SKbU9MC7g8tekQ/wfGrMy9pMdHwoR0=; b=deIop89GQvxb9Vua/zAZ6i3/9P5GR7IejFAnbAwHWGvnX+sZkcCMj35cN5U9dZSe4z djn3Bcx5DME1OtaLJA2xFpAhBDfk5NFagZFbY5WHs+8A8ESbxarwdZQLTYflMP258r8e x7vbUC6wPqAmSwGQjRDdsiRmJzuYls/G52W2aqghrl5Cue53wb3wNnZLnJoGzFIthmpH EVDuAvBP9iFJtDxlPe1h++S62WAPecVB1DVW79x3AA0H12o97qcpu0ZkjwknVee6q9z6 W+H5TyD6VZmQ3qLgtlCpEejcno92puemcQmVWIOsFdrmU2dTzIR7tcvsGfRaXwIF7lx0 8gKQ== X-Gm-Message-State: ALKqPwdZDtBG6/nGLy/VDtexmoJFtvXB7U7tUaCbMaj8j4k9Plw4gCp9 oS8a20Np5n/iRHY7LviZCeQz1v+USKSJhb1URWc= X-Google-Smtp-Source: ADUXVKI6/oUBgFf4/pwRtMDI8R55/6vy1HYl6ePz1odANt5gQomO4BGzNtqA2z9HlmUyVSdgQ3jZ87jkHgllbEyihsk= X-Received: by 2002:a25:bd49:: with SMTP id p9-v6mr13597662ybm.64.1528212505661; Tue, 05 Jun 2018 08:28:25 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a25:e051:0:0:0:0:0 with HTTP; Tue, 5 Jun 2018 08:28:25 -0700 (PDT) In-Reply-To: <1528211920098.8069@acceleris.ch> References: <1528211920098.8069@acceleris.ch> From: Shreeyansh Dba Date: Tue, 5 Jun 2018 20:58:25 +0530 Message-ID: Subject: Re: pgpool-II with PostgreSQL Streaming replication To: Pierre Ochsenbein Cc: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000008a97d9056de6b3c1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000008a97d9056de6b3c1 Content-Type: text/plain; charset="UTF-8" Go through the below link.. http://www.pgpool.net/docs/pgpool-II-3.5.4/doc/pgpool-en.html Hope this helps.. On Tue, Jun 5, 2018 at 8:48 PM, Pierre Ochsenbein < pierre.ochsenbein@acceleris.ch> wrote: > Dear all, > > > How to build pgpool-II with a PostgreSQL Streaming replication? > > Where I can find a documentation? > > > Thanks a lot. > > > Pierre > > [image: Acceleris] > > Acceleris AG | cloudifying IT > Pierre Ochsenbein | Technical Consultant > Schosshaldenstrasse 85 | CH-3006 Bern > > T : +41 31 911 33 22 | F : +41 31 911 62 63 > pierre.ochsenbein@acceleris.ch | www.acceleris.ch > > Acceleris Offices are in : > Bern | Zurich | Renens | Bucharest > > [image: Acceleris] > > > Disclaimer > > This message possibly contains confidential data or items of information. > It is intended solely for the rightful recipient. If you should have > received the message wrongfully, it is not permitted to disclose the e-mail > message or its contents to third parties, to copy or use it. We would > respectfully request you to destroy the message with the exclusion of any > reproduction and to notify this to the originator by e-mail. Thank you very > much. > > > > > --0000000000008a97d9056de6b3c1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Go through the below link..
http://www.pgpool.net/docs/pgpool-II-3.5.4/doc/pgpool-en.html
<= br>Hope this helps..




On Tue, Jun 5, 2018 at 8:48 PM, Pierre Ochse= nbein <pierre.ochsenbein@acceleris.ch> wrote:

Dear all,


How to build pgpool-II with a PostgreSQL Streaming replication?

Where I can find a documentation?


Thanks a lot.


Pierre


3D"Acceleris"

Acceleris AG= | cloudifying IT
Pierre Ochsenbein | Technical Consultant
Schosshaldenstrasse 85 | CH-3006 Ber= n
T : +41 31 911 33 22 | F : +41 31 911 62 63
pierre.= ochsenbein@acceleris.ch | www.acceleris.ch =C2=A0

Acceleris Offices are in :
Bern | Zurich | Renens | Bucharest
=C2=A0
3D"Acceleris"
=C2=A0

Disclaimer

This message possibly contains confidential data or items of information. I= t is intended solely for the rightful recipient. If you should have receive= d the message wrongfully, it is not permitted to disclose the e-mail messag= e or its contents to third parties, to copy or use it. We would respectfully request you to destroy the messag= e with the exclusion of any reproduction and to notify this to the originat= or by e-mail. Thank you very much.






--0000000000008a97d9056de6b3c1--