Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitbb20f2c

Browse files
committed
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 beforetimezone_abbreviations has been set. Which in turn means that zoneabbreviations don't work, only full zone names.We could imagine hacking things so that such cases do work, but thestability of the hack would be questionable, and the value isn't reallythat high. Instead just document that you should use a numeric zoneoffset 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
1 parent98c017c commitbb20f2c

File tree

1 file changed

+10
-0
lines changed

1 file changed

+10
-0
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3468,6 +3468,16 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
34683468
The precise stopping point is also influenced by
34693469
<xref linkend="guc-recovery-target-inclusive"/>.
34703470
</para>
3471+
3472+
<para>
3473+
The value of this parameter is a time stamp in the same format
3474+
accepted by the <type>timestamp with time zone</type> data type,
3475+
except that you cannot use a time zone abbreviation (unless the
3476+
<xref linkend="guc-timezone-abbreviations"/> variable has been set
3477+
earlier in the configuration file). Preferred style is to use a
3478+
numeric offset from UTC, or you can write a full time zone name,
3479+
e.g. <literal>Europe/Helsinki</literal> not <literal>EEST</literal>.
3480+
</para>
34713481
</listitem>
34723482
</varlistentry>
34733483

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp