Re: Postgres Automated Failover
От | Jehan-Guillaume (ioguix) de Rorthais |
---|---|
Тема | Re: Postgres Automated Failover |
Дата | |
Msg-id | 20190117150644.78fdf8fc@firost обсуждение исходный текст |
Ответ на | Postgres Automated Failover (AI Rumman <rummandba@gmail.com>) |
Ответы |
Re: Postgres Automated Failover
|
Список | pgsql-general |
On Thu, 17 Jan 2019 08:32:48 -0500 AI Rumman <rummandba@gmail.com> wrote: > Hi, > > I am planning to use Postgresql with TimescaleDb extension. I have to > design a system similar to AWS RDS which supports automated failover, > transparent minor version upgrades etc. > In early days, I worked with PgPool II to enable heartbeat between the > Postgres servers. Is there any new tool to achieve the same by which I can > design a transparent failover system for Postgres? There is multiple HA solutions, none are "transparent failover" though. They are just automated-failover. A rollback-ed transaction because of failover will never be transparent from the application point of view. Look at Patroni or PAF, depending on what you want to achieve.
В списке pgsql-general по дате отправления: