On Tue, Oct 8, 2019 at 9:58 AM Stephen Frost <sfr...@snowman.net> wrote: > From a user > perspective, what happens when you've started up PG as a primary, since > you don't have a signal file in place to indicate that you're doing > recovery, and you have a recovery_target set, so some user does > "show recovery_target_name" and sees a value? How is that sensible?
I'd argue that not only is it sensible, but it's the only correct answer. If I put a value in postgresql.conf and it doesn't show up in the output of SHOW, I'm going to be confused. That just seems flat wrong to me. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company