Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i2XV5-0004Vd-D3 for pgsql-admin@arkaria.postgresql.org; Tue, 27 Aug 2019 09:10: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 1i2XV2-0007We-Q8 for pgsql-admin@arkaria.postgresql.org; Tue, 27 Aug 2019 09:10:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i2X7d-0001cq-TJ for pgsql-admin@lists.postgresql.org; Tue, 27 Aug 2019 08:46:38 +0000 Received: from mx2.ondataport.de ([141.91.175.182]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1i2X7a-0002Wf-Jd for pgsql-admin@postgresql.org; Tue, 27 Aug 2019 08:46:36 +0000 Received: from mx2.ondataport.de (127.0.0.1) id hcjmtu0171s0 for ; Tue, 27 Aug 2019 10:45:33 +0200 (envelope-from ) Received: from ccms-out-hh.lclmspa020.dpaorvv.de ([10.61.127.10]) by mx2.ondataport.de ([10.61.98.71]) (DP Antispam) with ESMTPS (version=TLSv1 cipher=ECDHE-RSA-AES256-SHA bits=256/256) id o201908270845330193683-24; Tue, 27 Aug 2019 10:45:33 +0200 Received: from ccms-out-sbr.lclmspa020.dpaorvv.de (lclmspa020.dpaorvv.de [10.62.124.10]) by ccms-out-hh.lclmspa020.dpaorvv.de (Postfix) with ESMTP id 880847C038 for ; Tue, 27 Aug 2019 10:45:44 +0200 (CEST) Received: from WCLMSPA079.dpaorvv.de (wclmspa079.dpaorvv.de [10.62.30.79]) by ccms-out-sbr.lclmspa020.dpaorvv.de (Postfix) with ESMTPS id 86C656602A for ; Tue, 27 Aug 2019 10:45:44 +0200 (CEST) Received: from WCLMSPA079.dpaorvv.de (10.62.30.79) by WCLMSPA079.dpaorvv.de (10.62.30.79) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.1.1713.5; Tue, 27 Aug 2019 10:45:44 +0200 Received: from WCLMSPA079.dpaorvv.de ([fe80::606b:db51:8ef1:de6]) by WCLMSPA079.dpaorvv.de ([fe80::606b:db51:8ef1:de6%6]) with mapi id 15.01.1713.004; Tue, 27 Aug 2019 10:45:44 +0200 From: "AL-Temimi, Muthana" To: "pgsql-admin@postgresql.org" Subject: question Thread-Topic: question Thread-Index: AdVcswZoG82Y/nX+S5mqYCSHxai5Uw== Date: Tue, 27 Aug 2019 08:45:44 +0000 Message-ID: <17237c5450e64b5c962d4bb67e1103f6@tuhh.hamburg.de> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.63.255.14] x-tm-snts-smtp: 82E52312FC0DF48DD2934EDC63E3299D2BE123F42C0D3D37AAACB54D285AA9312 Content-Type: multipart/alternative; boundary="_000_17237c5450e64b5c962d4bb67e1103f6tuhhhamburgde_" MIME-Version: 1.0 X-Mlf-CnxnMgmt-Allow: 10.61.127.10 X-Mlf-Version: 9.2.2.5291 X-Mlf-License: BSVKCAP___ X-Mlf-UniqueId: o201908270845330193683 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_17237c5450e64b5c962d4bb67e1103f6tuhhhamburgde_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Dear all, I have 2 different Master/Slave with two different databases (DB1 und DB2)= . My question is: Can I manage them both with one PGPool II? Can PGPool II = recognize that the first request should go to the fist Master/Slave because= the request talk with DB1 and the 2nd request, which are talk to DB2, sho= uld go the 2nd Master/Slave. Regards Muthana --_000_17237c5450e64b5c962d4bb67e1103f6tuhhhamburgde_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Dear all,

 

I have 2 different  Master= /Slave with two different databases (DB1 und DB2). My question is: Can I ma= nage them both with one PGPool II? Can PGPool II recognize that the first r= equest should go to the fist Master/Slave because the request talk with DB1 and the 2nd request, which ar= e talk to DB2,  should go the 2nd Master/Slave.<= /span>

 

Regards

Muthana

--_000_17237c5450e64b5c962d4bb67e1103f6tuhhhamburgde_--