Re: Postgres Automated Failover

2019-01-17 Thread AI Rumman
Thanks, I'll check it out. On Thu, Jan 17, 2019 at 9:06 AM Jehan-Guillaume (ioguix) de Rorthais < iog...@free.fr> wrote: > On Thu, 17 Jan 2019 08:32:48 -0500 > AI Rumman wrote: > > > Hi, > > > > I am planning to use Postgresql with TimescaleDb extension. I have to > > design a system similar to

RE: Postgres Automated Failover

2019-01-17 Thread ROS Didier
 : pgsql-general@lists.postgresql.org Objet : Re: Postgres Automated Failover Hi, In my opinion repmgr it's worth a look. https://repmgr.org/ regards, fabio pardi On 17/01/2019 14:32, AI Rumman wrote: > Hi, > > I am planning to use Postgresql with TimescaleDb extension. I have

Re: Postgres Automated Failover

2019-01-17 Thread Fabio Pardi
Hi, In my opinion repmgr it's worth a look. https://repmgr.org/ regards, fabio pardi On 17/01/2019 14:32, AI Rumman 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 >

Re: Postgres Automated Failover

2019-01-17 Thread Jehan-Guillaume (ioguix) de Rorthais
On Thu, 17 Jan 2019 08:32:48 -0500 AI Rumman 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

Re: Postgres Automated Failover

2019-01-17 Thread Deepika S Gowda
There is postgres multimaster replication. Please explore bdr multi master node. On Thu, Jan 17, 2019 at 7:03 PM AI Rumman 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

Postgres Automated Failover

2019-01-17 Thread AI Rumman
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