pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCustomize Postgresql HA structure
2+ messages / 2 participants
[nested] [flat]
* Customize Postgresql HA structure
@ 2019-06-10 08:37 盧致均(Harry) <harry@linktech.com.tw>
0 siblings, 1 reply; 2+ messages in thread
From: 盧致均(Harry) @ 2019-06-10 08:37 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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*
*______________________________________*
*[image: linktech_logo2]*
*Linktech Inc.*
*220*
*新北市板橋區民生路一段3號13樓之2*
*Phone:+886-2-2959-9166#160 <+886%202%207703%201979>*
*E-mail: harry@linktech.com.tw <harry@linktech.com.tw>**Web:
www.linktech.com.tw
<http://www.linktech.com.tw/>*
Attachments:
image001.jpg (image/jpeg, 8.0K) download
view image
* Re: Customize Postgresql HA structure
@ 2019-06-10 21:14 Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
parent: 盧致均(Harry) <harry@linktech.com.tw>
0 siblings, 0 replies; 2+ messages in thread
From: Jehan-Guillaume (ioguix) de Rorthais @ 2019-06-10 21:14 UTC (permalink / raw)
To: 盧致均(Harry) <harry@linktech.com.tw>; +Cc: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-06-10 21:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-06-10 08:37 Customize Postgresql HA structure 盧致均(Harry) <harry@linktech.com.tw>
2019-06-10 21:14 ` Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox