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

Commit7dfd5cd

Browse files
committed
Clarify terminology standalone backend vs. single-user mode
Most of the documentation uses "single-user mode", so use that in thecode as well. Adjust the documentation to match the new error messagewording. Also add a documentation index entry for "single-user mode".Based-on-patch-by: Jeff Janes <jeff.janes@gmail.com>
1 parent4c54e87 commit7dfd5cd

File tree

3 files changed

+12
-8
lines changed

3 files changed

+12
-8
lines changed

‎doc/src/sgml/maintenance.sgml

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -581,17 +581,17 @@ HINT: To avoid a database shutdown, execute a database-wide VACUUM in "mydb".
581581

582582
<programlisting>
583583
ERROR: database is not accepting commands to avoid wraparound data loss in database "mydb"
584-
HINT: Stop the postmaster anduse a standalone backend to VACUUMin"mydb".
584+
HINT: Stop the postmaster andvacuum that databaseinsingle-user mode.
585585
</programlisting>
586586

587587
The 1-million-transaction safety margin exists to let the
588588
administrator recover without data loss, by manually executing the
589589
required <command>VACUUM</> commands. However, since the system will not
590590
execute commands once it has gone into the safety shutdown mode,
591-
the only way to do this is to stop the server anduse a single-user
592-
backend to execute <command>VACUUM</>. The shutdown mode is not enforced
593-
by asingle-userbackend. See the <xref linkend="app-postgres"> reference
594-
page for details about usingasingle-userbackend.
591+
the only way to do this is to stop the server andstart the server in single-user
592+
mode to execute <command>VACUUM</>. The shutdown mode is not enforced
593+
insingle-usermode. See the <xref linkend="app-postgres"> reference
594+
page for details about using single-usermode.
595595
</para>
596596

597597
</sect2>

‎doc/src/sgml/ref/postgres-ref.sgml

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -529,6 +529,10 @@ PostgreSQL documentation
529529
<refsect2>
530530
<title>Options for Single-User Mode</title>
531531

532+
<indexterm>
533+
<primary>single-user mode</primary>
534+
</indexterm>
535+
532536
<para>
533537
The following options only apply to the single-user mode.
534538
</para>

‎src/backend/access/transam/varsup.c

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -73,7 +73,7 @@ GetNewTransactionId(bool isSubXact)
7373
* If we're past xidVacLimit, start trying to force autovacuum cycles.
7474
* If we're past xidWarnLimit, start issuing warnings.
7575
* If we're past xidStopLimit, refuse to execute transactions, unless
76-
* we are running ina standalone backend (which gives an escape hatch
76+
* we are running insingle-user mode (which gives an escape hatch
7777
* to the DBA who somehow got past the earlier defenses).
7878
*
7979
* Note that this coding also appears in GetNewMultiXactId.
@@ -114,14 +114,14 @@ GetNewTransactionId(bool isSubXact)
114114
(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
115115
errmsg("database is not accepting commands to avoid wraparound data loss in database \"%s\"",
116116
oldest_datname),
117-
errhint("Stop the postmaster anduse a standalone backend tovacuum that database.\n"
117+
errhint("Stop the postmaster and vacuum that database in single-user mode.\n"
118118
"You might also need to commit or roll back old prepared transactions.")));
119119
else
120120
ereport(ERROR,
121121
(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
122122
errmsg("database is not accepting commands to avoid wraparound data loss in database with OID %u",
123123
oldest_datoid),
124-
errhint("Stop the postmaster anduse a standalone backend tovacuum that database.\n"
124+
errhint("Stop the postmaster and vacuum that database in single-user mode.\n"
125125
"You might also need to commit or roll back old prepared transactions.")));
126126
}
127127
elseif (TransactionIdFollowsOrEquals(xid,xidWarnLimit))

0 commit comments

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