From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | 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 15:11:45 |
Message-ID: | CAKFQuwZ8_+zpBo7sZCkN5VKSB8n0tehgZXnbrd514j8RQ6EdNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Amit jain | 2021-01-19 15:15:31 | Re: Table Partitioning |
Previous Message | Graham Everton | 2021-01-19 15:00:41 | Re: Table Partitioning |