Re: PostgreSQL Automatic Failover Windows Server

2021-08-19 Thread Laurenz Albe
On Wed, 2021-08-18 at 21:18 +0530, Heljeeve C Unni wrote: > I want to know in detail about PostgreSQL Automatic Failover solutions > without third party tools. > > Installation procedures step by step on WINDOWS SERVER. You could have a look at this: https://github.com/cyberte

Re: PostgreSQL Automatic Failover Windows Server

2021-08-18 Thread Bruce Momjian
On Wed, Aug 18, 2021 at 11:57:24PM +0530, Vijaykumar Jain wrote: > > I want to know in detail about PostgreSQL Automatic Failover solutions > without third party tools. >   > There is no automatic failover solution provided with core postgresql. (maybe > EDB provi

Re: PostgreSQL Automatic Failover Windows Server

2021-08-18 Thread Vijaykumar Jain
> > > I want to know in detail about PostgreSQL Automatic Failover solutions > without third party tools. > > There is no automatic failover solution provided with core postgresql. (maybe EDB provides in windows but ...) there are third party OSS solutions, dhamaniasad/awesome-p

PostgreSQL Automatic Failover Windows Server

2021-08-18 Thread Heljeeve C Unni
availability system we are mirroring the DATABASES using in built technology of MS SQL SERVER MIRRORING and it's running smoothly. Now we are wth a plan to migrate the databases to PostgresSQL. Database development has been started. I want to know in detail about PostgreSQL Automatic Failover solu

Re: Automatic failover

2020-03-17 Thread Ian Barwick
On 2020/03/17 19:30, Sonam Sharma wrote: > I have setup replication using repmgr. Wanted to know how much time > the slave node will take to become new primary ?? If any document, > can someone please share of auto failover. With automatic failover, > how much time the slave takes t

Re: Automatic failover

2020-03-17 Thread Paul Foerster
Hi Sonam, On Tue, Mar 17, 2020 at 11:30 AM Sonam Sharma wrote: > > I have setup replication using repmgr. Wanted to know how much time the slave > node will take to become new primary ?? If any document, can someone please > share of auto failover. With automatic failover, how m

Automatic failover

2020-03-17 Thread Sonam Sharma
I have setup replication using repmgr. Wanted to know how much time the slave node will take to become new primary ?? If any document, can someone please share of auto failover. With automatic failover, how much time the slave takes to become new primary . Thanks..

Re: Automatic Failover in PostgreSQL using PAF/repmgr

2019-06-29 Thread Jehan-Guillaume (ioguix) de Rorthais
x27;s. > > Now I am trying to integrate the Failover part to Automatic Failover using > PAF (Postgresql automatic Failover) or repmgr. Well, this requires a lot a time to understand, setup and master the automatic failover you are building. First advice: consider Patroni as well. Second adv

Automatic Failover in PostgreSQL using PAF/repmgr

2019-06-29 Thread Devendra Y
Dear Experts, I have configured Wal replication (standby) in PostgreSQL as Master and slave. And I have also configured Logical replication (standby) in PostgreSQL as Master and slave for different application's. Now I am trying to integrate the Failover part to Automatic Failover usin

repmgr and automatic failover

2019-01-18 Thread ROS Didier
Hi It seems that after an automatic failover by repmgr, it is possible to start the old primary instance. ( SPLIT BRAIN Risk) . For example: the case when we make a reboot of the primary server, so there is an automatic failover made by repmgr and in this situation, we end up with 2 primary