From: | Rajni Baliyan <saan654(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Ankush Chawla <ankushchawla03(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: hot standby in Postgresql 12 |
Date: | 2021-01-19 21:55:54 |
Message-ID: | CAG5RORO+JgbM6vHZwiZPNURf1mYqLsL6xz9LNG+gY3+zxbpvzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
As David highlighted,
>> I took the error from the cp command to mean that this was in fact a
warm standby regardless of any claims by the poster. I’ll readily admit I
am not that familiar with this stuff though.
Seems your archive command is not working properly. Set it first and then
try again.
Also, please share your postgresql.auto.conf ( remove confidential
information like - password , username , IP etc. , if any)
Regards
Rajni
On Wed, Jan 20, 2021 at 2:11 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Tuesday, January 19, 2021, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
> wrote:
>
>>
>> > > cp: cannot stat '/u01/archive/000000030000000000000035': No such file
>> or directory
>> > > 2021-01-18 07:31:01.043 UTC [21079]LOG: started streaming WAL from
>> primary at 0/35000000 on timeline 3
>> > >
>> >
>> > And now the standby is waiting for the next wal file to be archived by
>> the primary.
>> > You should probably set archive_timeout to a non-zero value since the
>> primary doesn’t
>> > seem very busy (though you also still need to do at least one write,
>> empty wal files
>> > don’t get rotated out and archived.)
>>
>> If the standby is *streaming* WAL, it is *not* waiting for a WAL segment
>> to be archived.
>> WAL is streamed to the standby right away.
>>
>
> I took the error from the cp command to mean that this was in fact a warm
> standby regardless of any claims by the poster. I’ll readily admit I am
> not that familiar with this stuff though.
>
> David J.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2021-01-19 22:03:47 | Re: hot standby in Postgresql 12 |
Previous Message | Scott Ribe | 2021-01-19 21:27:50 | Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" |