Thread: Customize Postgresql HA structure

Customize Postgresql HA structure

From
盧致均(Harry)
Date:
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?

--
Thank you & Best Regards

Harry Lu

______________________________________

linktech_logo2

Linktech Inc.

220新北市板橋區民生路一段3號13樓之2
Phone:+886-2-2959-9166#160
E-mail: harry@linktech.com.tw
Web: www.linktech.com.tw

Attachment

Re: Customize Postgresql HA structure

From
"Jehan-Guillaume (ioguix) de Rorthais"
Date:
On Mon, 10 Jun 2019 16:37:55 +0800
盧致均(Harry) <harry@linktech.com.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.