Thread: Warn about using single user + standby_mode
Hi, When primary_conninfo is configured and standby_mode is enabled single user mode starts up, but at some point will just wait in a latch for WAL to show up. Which will obviously never happen as walreceiver isn't up. Should we just error out in that case, or at least display a log message about that fact? Greetings, Andres Freund
On Fri, Jun 5, 2015 at 9:59 PM, Andres Freund <andres@anarazel.de> wrote:
>
> Hi,
>
> When primary_conninfo is configured and standby_mode is enabled single
> user mode starts up, but at some point will just wait in a latch for WAL
> to show up. Which will obviously never happen as walreceiver isn't up.
>
> Should we just error out in that case, or at least display a log message
> about that fact?
>
>
> Hi,
>
> When primary_conninfo is configured and standby_mode is enabled single
> user mode starts up, but at some point will just wait in a latch for WAL
> to show up. Which will obviously never happen as walreceiver isn't up.
>
So this essentially means as it stands single user mode can't work
for standby.
> Should we just error out in that case, or at least display a log message
> about that fact?
>
I think error is better in this case as there seems no chance for
user to proceed in this case. It is even better if we can detect
this early and error out before even reaching the stage where it
starts waiting out for WAL to show up.