On Mon, 10 Jun 2019 16:37:55 +0800 盧致均(Harry) <harry@xxxxxxxxxxxxxxx> 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.
