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 1gQ8UL-0007Td-Ss for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 10:15:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQ8UI-0005bH-Lb for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 10:15:02 +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 1gQ8UI-0005au-5K for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 10:15:02 +0000 Received: from mx2.stadt-zuerich.ch ([194.56.33.11]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQ8UE-0003jZ-DD for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 10:15:00 +0000 X-IronPort-AV: E=Sophos;i="5.56,269,1539640800"; d="scan'208,217";a="23755805" Received: from unknown (HELO SZHM27376.global.szh.loc) ([10.7.50.80]) by mx2.prm.szh.zone with ESMTP/TLS/AES256-GCM-SHA384; 23 Nov 2018 11:14:55 +0100 Received: from SZHM27370.global.szh.loc (10.7.50.50) by SZHM27376.global.szh.loc (10.7.50.80) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.1415.2; Fri, 23 Nov 2018 11:14:54 +0100 Received: from SZHM27370.global.szh.loc ([fe80::2839:247b:c8d4:9198]) by SZHM27370.global.szh.loc ([fe80::2839:247b:c8d4:9198%11]) with mapi id 15.01.1415.002; Fri, 23 Nov 2018 11:14:54 +0100 From: "Zwettler Markus (OIZ)" To: "pgsql-admin@lists.postgresql.org" Subject: pgpool2 HA + split brain Thread-Topic: pgpool2 HA + split brain Thread-Index: AdSDFR9hChU+UfMjSzWJ2ErSAPrZGQ== Date: Fri, 23 Nov 2018 10:14:54 +0000 Message-ID: <07b006680f7249b6a8fa437b9bc1121d@zuerich.ch> Accept-Language: de-CH, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.7.48.250] Content-Type: multipart/alternative; boundary="_000_07b006680f7249b6a8fa437b9bc1121dzuerichch_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_07b006680f7249b6a8fa437b9bc1121dzuerichch_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi all, I am thinking about a HA solution using pgpool2 + postgresql streaming repl= ication. I am afraid of a split brain scenario (two active primary databases). In my opinion a split brain scenario should never happen when a) I configure the postgresql clusters (pg_hba.conf) to accept only user= connections coming from the pgpool2 server b) pgpool2 initiates the failover Do you agree or did I miss something? Thanks, Markus --_000_07b006680f7249b6a8fa437b9bc1121dzuerichch_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi all,<= /span>

I am= thinking about a HA solution using pgpool2 + postgresql streaming repl= ication.

I am= afraid of a split brain scenario (two active primary databases).

In m= y opinion a split brain scenario should never happen when=

a) I configure the postgresql clusters (pg_hba.conf) to accept only user c= onnections coming from the pgpool2 server

b) pgpool2 initiates the failover

Do y= ou agree or did I miss something?

Than= ks,

Mark= us

--_000_07b006680f7249b6a8fa437b9bc1121dzuerichch_--