Re: Customize Postgresql HA structure

On Mon, 10 Jun 2019 16:37:55 +0800
盧致均(Harry) <harry(at)linktech(dot)com(dot)tw> wrote:

> Hi Team,
>
> Can we build a HA structure with 2 standalone Postgresql-server?
>
> In the theory,we should can build Postgresql-server in shared storage,
>
> then we will prepare another cold standby Postgresql-server listening to
> the active server.
>
> When the active crash or shutdown,the cold standby server will auto replace
> original server.
>
> 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 architecture.

Good luck.