Doc: warn that timezone abbreviations don't work in recovery_target_time.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 5 May 2020 20:06:49 +0000 (16:06 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 5 May 2020 20:06:49 +0000 (16:06 -0400)
commitbefa0e471e021cadcac9644a322eb6e4c0e6f524
tree130f4f48aa2f7c574c33e9ba70acb9f6d530fb94
parent987717d7c7007055ff7fc2ecf3d40e9bdb00e071
Doc: warn that timezone abbreviations don't work in recovery_target_time.

Moving this setting into the main configuration file was ill-considered,
perhaps, because that typically causes it to be set before
timezone_abbreviations has been set.  Which in turn means that zone
abbreviations don't work, only full zone names.

We could imagine hacking things so that such cases do work, but the
stability of the hack would be questionable, and the value isn't really
that high.  Instead just document that you should use a numeric zone
offset or a full zone name.

Per bug #16404 from Reijo Suhonen.
Back-patch to v12 where this was changed.

Discussion: https://postgr.es/m/16404-4603a99603fbd04c@postgresql.org
doc/src/sgml/config.sgml