Now I am confused. In Primary pg_is_in_recovery() should be false and in standby node should be true. Am I wrong?
Thanks and regards Alpaslan On Thu, Feb 8, 2024 at 9:10 PM Laurenz Albe <laurenz.a...@cybertec.at> wrote: > On Thu, 2024-02-08 at 09:23 +0100, Alpaslan AKDAĞ wrote: > > Thank you for your answer. > > > > I have checked the pg_is_in_recovery() and here are the results > > from primary and hot stand by server. > > > > Primary (old standby ): > > select pg_is_in_recovery(); > > pg_is_in_recovery > > ------------------- > > f > > (1 row) > > > > hot standby(old primary): > > select pg_is_in_recovery(); > > pg_is_in_recovery > > ------------------- > > t > > (1 row) > > and there is also standby.signal file in standby server. > > So it seems that there is nothing wrong. > > > > recovery_min_apply_delay = '2d' are set in warm standby servers. > > Before the switchover we had the same settings but we did not have this > problem. > > It is becoming increasingly obvious that you never actually performed > a switchover: it seems that you didn't promote the standby. > > Either use > > pg_ctl promote -D /path/to/datadir > > on the command line or > > SELECT pg_promote(); > > in SQL. > > Yours, > Laurenz Albe >
