Hi,
> > - I brought down the active instance by executing 'pg_ctl -D
> > /home/postgres/postgresHSB/actdata stop' hoping that trigger file
will
> > enable failover. But I was not able to login to standby instance.
Not
> > sure why?
>
> Please let me know the failover procedure which you carried
> out. As follows?
>
> 1) pg_ctl -D /home/postgres/postgresHSB/actdata stop
> 2) touch /home/postgres/postgresHSB/finish.trigger
Yes. This the procedure that I followed. I have attached the relevant
logs.
"change_standby_mode.log" - Commands used to change from continous
recovery mode of the standby instance
"ps.log" - ps command before and after executing the SQL.
Regards,
Niranjan