diff options
| author | Noah Misch <noah@leadboat.com> | 2024-05-16 14:11:00 -0700 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2024-05-16 14:11:00 -0700 |
| commit | 372700cf3067254317e7e8060662f8fac11500d5 (patch) | |
| tree | 4cb1af4322e066c1f19e3c1a2cbd819e44480f0b /doc/src | |
| parent | a3e6c6f929912f928fa405909d17bcbf0c1b03ee (diff) | |
| download | postgresql-372700cf3067254317e7e8060662f8fac11500d5.tar.gz postgresql-372700cf3067254317e7e8060662f8fac11500d5.zip | |
Fix documentation about DROP DATABASE FORCE process termination rights.
Specifically, it terminates a background worker even if the caller
couldn't terminate the background worker with pg_terminate_backend().
Commit 3a9b18b3095366cd0c4305441d426d04572d88c1 neglected to update
this. Back-patch to v13, which introduced DROP DATABASE FORCE.
Reviewed by Amit Kapila. Reported by Kirill Reshke.
Discussion: https://postgr.es/m/20240429212756.60.nmisch@google.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/drop_database.sgml | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml index ff01450ba77..55c52ae93bc 100644 --- a/doc/src/sgml/ref/drop_database.sgml +++ b/doc/src/sgml/ref/drop_database.sgml @@ -79,12 +79,14 @@ DROP DATABASE [ IF EXISTS ] <replaceable class="parameter">name</replaceable> [ It doesn't terminate if prepared transactions, active logical replication slots or subscriptions are present in the target database. </para> + <!-- not mentioning exception for autovacuum workers, since those are an + implementation detail and the exception is not specific to FORCE --> <para> - This will fail if the current user has no permissions to terminate other - connections. Required permissions are the same as with - <literal>pg_terminate_backend</literal>, described in - <xref linkend="functions-admin-signal"/>. This will also fail if we - are not able to terminate connections. + This terminates background worker connections and connections that the + current user has permission to terminate + with <function>pg_terminate_backend</function>, described in + <xref linkend="functions-admin-signal"/>. If connections would remain, + this command will fail. </para> </listitem> </varlistentry> |