Date: Mon, 10 Jun 2019 23:14:46 +0200
From: "Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr>
To: "=?UTF-8?B?55un6Ie05Z2H?=(Harry)" <harry@linktech.com.tw>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Customize Postgresql HA structure
Message-ID: <20190610231446.1ac1e8d5@firost>
In-Reply-To: 
 <CAPe_R0b-_r2Zg9YM=E-9O0N4HpV26iaOB788RnLHC5p9_TMDKg@mail.gmail.com>
References: 
 <CAPe_R0b-_r2Zg9YM=E-9O0N4HpV26iaOB788RnLHC5p9_TMDKg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

On Mon, 10 Jun 2019 16:37:55 +0800
=E7=9B=A7=E8=87=B4=E5=9D=87(Harry) <harry@linktech.com.tw> wrote:

> Hi Team,
>=20
> Can we build a HA structure with 2 standalone Postgresql-server?
>=20
> In the theory,we should can build Postgresql-server in shared storage,
>=20
> then we will prepare another cold standby Postgresql-server listening to
> the active server.
>=20
> When the active crash or shutdown,the cold standby server will auto repla=
ce
> original server.
>=20
> Is this feasible?Or where can we find related article?

Yes. Under Linux, you would have to use Pacemaker with:

* a decent SAN
* IO fencing and/or node feneing
* resource agent "Filesystem"

If I remember correctly, there was a HA cookbook describing this architectu=
re.

Good luck.