Re: PostgreSQL switchover process

2020-08-24 Thread rams nalabolu
Yes, I did. On Mon, Aug 24, 2020 at 10:43 PM Fujii Masao wrote: > > > On 2020/08/25 11:22, Michael Paquier wrote: > > On Mon, Aug 24, 2020 at 03:56:43PM -0400, rams nalabolu wrote: > >> I did the following steps to perform switchover > >> 1) ran a checkpoint on primary. > >> 2) verified secondar

Re: PostgreSQL switchover process

2020-08-24 Thread Fujii Masao
On 2020/08/25 11:22, Michael Paquier wrote: On Mon, Aug 24, 2020 at 03:56:43PM -0400, rams nalabolu wrote: I did the following steps to perform switchover 1) ran a checkpoint on primary. 2) verified secondary status and it is up to date with primary. 3) stopped primary using pg_ctl -mf i.e fo

Re: PostgreSQL switchover process

2020-08-24 Thread Michael Paquier
On Mon, Aug 24, 2020 at 03:56:43PM -0400, rams nalabolu wrote: > I did the following steps to perform switchover > 1) ran a checkpoint on primary. > 2) verified secondary status and it is up to date with primary. > 3) stopped primary using pg_ctl -mf i.e force. This is not a force mode, but the fa

PostgreSQL switchover process

2020-08-24 Thread rams nalabolu
Hi All, I'm trying to do the Switchover process in postgres. 1) I have my primary cluster running on port 5432 on server A 2) secondary cluster on the port 5432 on server B I did setup streaming replication b/w primary and secondary using replication slots. I did the following steps to perform s