On Thu, 2024-02-08 at 21:28 +0100, Alpaslan AKDAĞ wrote:
> Now I am confused. In Primary pg_is_in_recovery() should be false and in
> standby node should be true. Am I wrong?
Right. I guess I got confused which is your primary and which is your
standby. That's normal in the context of switchover
Thank you very much.
I got my answer and also read from the documentation. Primary and standby
both seem fine.
Best Regards
Alpaslan
On Thu, Feb 8, 2024 at 9:39 PM Mateusz Henicz
wrote:
> Hey,
> Yes, it is.
>
> https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-ARCHIVE-MODE
>
Hey,
Yes, it is.
https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-ARCHIVE-MODE
czw., 8 lut 2024 o 21:35 Alpaslan AKDAĞ
napisał(a):
> Hello Mateusz
>
> Thank you for your answer.
>
> If it is like that, there is not any problem. I tried to find an
> explanation that hot standby
Hello Mateusz
Thank you for your answer.
If it is like that, there is not any problem. I tried to find an
explanation that hot standby archive wal files or not but I couldn't.
Is this information from the Documentation?
Best Regards,
Alpaslan
On Thu, Feb 8, 2024 at 9:24 PM Mateusz Henicz
wrot
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
wrote:
> On Thu, 2024-02-08 at 09:23 +0100, Alpaslan AKDAĞ wrote:
> > Thank you for your answer.
> >
> > I ha
czw., 8 lut 2024 o 21:10 Laurenz Albe napisał(a):
> 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
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
> ---
>
Hello Laurenz,
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_recover
On Wed, 2024-02-07 at 12:07 +0100, Alpaslan AKDAĞ wrote:
> We have a primary, a hot standby and 2 warm standby servers with 2 days delay.
>
> After switchover since 01.02.2024 hot standby server does not archive wal
> files. I couldn't find the problem.
>
> related postgresql.conf lines:
> arch
Hello
We have a primary, a hot standby and 2 warm standby servers with 2 days
delay.
After switchover since 01.02.2024 hot standby server does not archive wal
files. I couldn't find the problem.
Hot Standby Server infos:
Redhat Enterprise Linux 9.2
postgreSQL v13.10
related postgresql.conf line
10 matches
Mail list logo
