Re: Reporting WAL replay progress during pre-consistency standby reovery

Hi Kiril,

> During recovery, if you try to connect to the database via psql, you
> will get an error message: "the database system is not yet accepting
> connection"/"Consistent recovery state has not been yet reached." etc.
> What if we report the current replay LSN here?

Thanks for the suggestion. Since crash recovery already reports replay
progress through the server log, I think using the same mechanism for
standby recovery before consistency is preferable than introducing a
different reporting method.

Also, this connection error is returned before authentication, so
adding the replay LSN would expose recovery information to
unauthenticated clients and may need separate consideration.

For this patch, I would prefer to keep the existing server-log
approach, while the connection-error approach can be explored
separately.

Best Regards,
Nitin Jadhav
Microsoft