Re: Warn about using single user + standby_mode - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Warn about using single user + standby_mode
Date
Msg-id CAA4eK1L5mGnyrV8r0KytorpsjeiREbdhQo=9Se3kXoeCQXjSEg@mail.gmail.com
Whole thread Raw
In response to Warn about using single user + standby_mode  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
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.
>

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.


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
Next
From: Bruce Momjian
Date:
Subject: Re: [CORE] Restore-reliability mode