pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStartup process in slave
3+ messages / 2 participants
[nested] [flat]
* Startup process in slave
@ 2020-04-25 13:12 Raj kumar <rajkumar820999@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Raj kumar @ 2020-04-25 13:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
I could see that there is zero replication lag between master and slave.
But, slave has startup process always recovering along with wal receiver
streaming.
I thought after startup process stops recovering, then only wal receiver
will start receiving files from wal sender. Then startup process will be
stopped.
In pg 9.6, I have always seen, only walreceiver running. But currently, in
Pg11, I see startup process in addition. May be it's not version specific.
I'm just adding more information.
Can you please clarify why startup process is running even after
walreceiver came up?
Thanks
Raj
Attachments:
20200425_183828.jpg (image/jpeg, 2.8M) download
view image
* Re: Startup process in slave
@ 2020-04-25 21:24 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Raj kumar <rajkumar820999@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Ribe @ 2020-04-25 21:24 UTC (permalink / raw)
To: Raj kumar <rajkumar820999@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
> On Apr 25, 2020, at 7:12 AM, Raj kumar <rajkumar820999@gmail.com> wrote:
>
> But, slave has startup process always recovering along with wal receiver streaming.
Yes, it will always be recovering, that's how it works. Wal receiver gets the logs, but startup recovery process applies them.
> In pg 9.6, I have always seen, only walreceiver running.
Are you sure about that?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Startup process in slave
@ 2020-04-26 12:29 Raj kumar <rajkumar820999@gmail.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 3+ messages in thread
From: Raj kumar @ 2020-04-26 12:29 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Scott,
Thanks for the explanation. I think, my understanding was wrong. Thanks for
your clarification
Thanks
Raj
On Sun, Apr 26, 2020 at 2:54 AM Scott Ribe <scott_ribe@elevated-dev.com>
wrote:
> > On Apr 25, 2020, at 7:12 AM, Raj kumar <rajkumar820999@gmail.com> wrote:
> >
> > But, slave has startup process always recovering along with wal
> receiver streaming.
>
> Yes, it will always be recovering, that's how it works. Wal receiver gets
> the logs, but startup recovery process applies them.
>
> > In pg 9.6, I have always seen, only walreceiver running.
>
> Are you sure about that?
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-04-26 12:29 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-04-25 13:12 Startup process in slave Raj kumar <rajkumar820999@gmail.com>
2020-04-25 21:24 ` Scott Ribe <scott_ribe@elevated-dev.com>
2020-04-26 12:29 ` Raj kumar <rajkumar820999@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox