Re: Postgres Stream Replication Failover Questions

Hi Mahmoud,
Please find answers in line...

On Wed, Mar 27, 2019, at 12:07 PM Mahmoud Moharam <mmoharam(at)lucidya(dot)com>
wrote:

> Dear All ,
> as I try to configure Postgres Stream Replication Failover strategy some
> questions pop-up so can you please help on answering these concerns
> 1. What happens to the master server when I kill the slave server?
>
It depends on what type replication mode, you use.
i. In case synchronous replication master-slave always running if
slave not available then master goes to waiting state.
ii. In case asynchronous replication if slave not available, then
master server work.

> 2. Is replication going to affect insert speed on the master server?
>
All write operation performed on master server only. To improve performance
you can use slave for select operations.

> 3. What happens when I kill master and slave is running? is there an
> automatic way to check and auto promote ?
>
If Master kills, then Slave is continue running in recovery mode. You can
manually promote the Slave as Master. There are so many tools available to
perform the auto failover.

> 4. If I started inserting into slave (which will become master) server
> until old master is back, do I have to reverse the configuration?
>
Yes, you can rebulid manually. There are so many tools available to perform
the auto switchover.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com