Document recovery_target_action behavior?

From: David Steele <david(at)pgmasters(dot)net>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Document recovery_target_action behavior?
Date: 2019-09-27 17:52:38
Message-ID: c39ffa6a-f44f-bab4-853b-66157ca8d90f@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers,

In versions < PG12 recovery_target_action has a behavior that appears to
be a bug, or is at least undocumented. If hot_standby = off and
recovery_target_action is not specified then the cluster will promote
when the target is found rather than shutting down as the documentation
seems to indicate. If recovery_target_action is explicitly set to pause
then the cluster will shutdown as expected.

In PG12 the shutdown occurs even when recovery_target_action is not
explicitly set. This seems like good behavior and it matches the
documentation as I read it.

The question for the old versions: is this something that should be
fixed in the code or in the documentation?

My vote is to make this explicit in the documentation, since changing
the recovery behavior in old versions could lead to nasty surprises.

Regards,
--
-David
david(at)pgmasters(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2019-09-27 17:53:34 Re: pg_upgrade issues
Previous Message Robert Haas 2019-09-27 17:51:30 Re: Minimal logical decoding on standbys