diff options
| author | Bruce Momjian <bruce@momjian.us> | 2008-04-15 13:55:12 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2008-04-15 13:55:12 +0000 |
| commit | 18b286f3e3317c26f27ead1dea8be23c63a7ef2a (patch) | |
| tree | 380518a08736536d69901e2e9c0a13594a101d63 /doc/src | |
| parent | fcf053d7829f2d83829256153e856f9a36c83ffd (diff) | |
| download | postgresql-18b286f3e3317c26f27ead1dea8be23c63a7ef2a.tar.gz postgresql-18b286f3e3317c26f27ead1dea8be23c63a7ef2a.zip | |
Add pg_terminate_backend() to allow terminating only a single session.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 19 | ||||
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 9 |
2 files changed, 23 insertions, 5 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index d2af5e63ee8..995d1ae9d35 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.430 2008/04/14 17:05:32 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.431 2008/04/15 13:55:11 momjian Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -11849,6 +11849,9 @@ SELECT set_config('log_statement_stats', 'off', false); <primary>pg_cancel_backend</primary> </indexterm> <indexterm> + <primary>pg_terminate_backend</primary> + </indexterm> + <indexterm> <primary>pg_reload_conf</primary> </indexterm> <indexterm> @@ -11885,6 +11888,13 @@ SELECT set_config('log_statement_stats', 'off', false); </row> <row> <entry> + <literal><function>pg_terminate_backend</function>(<parameter>pid</parameter> <type>int</>)</literal> + </entry> + <entry><type>boolean</type></entry> + <entry>Terminate a backend</entry> + </row> + <row> + <entry> <literal><function>pg_reload_conf</function>()</literal> </entry> <entry><type>boolean</type></entry> @@ -11907,9 +11917,10 @@ SELECT set_config('log_statement_stats', 'off', false); </para> <para> - <function>pg_cancel_backend</> sends a query cancel - (<systemitem>SIGINT</>) signal to a backend process identified by - process ID. The process ID of an active backend can be found from + <function>pg_cancel_backend</> and <function>pg_terminate_backend</> + send a query cancel (<systemitem>SIGINT</>) signal to a backend process + identified by process ID. The + process ID of an active backend can be found from the <structfield>procpid</structfield> column in the <structname>pg_stat_activity</structname> view, or by listing the <command>postgres</command> processes on the server with diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 1c799d8965b..c5222440fc8 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.411 2008/03/31 02:43:14 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.412 2008/04/15 13:55:11 momjian Exp $ --> <chapter Id="runtime"> <title>Operating System Environment</title> @@ -1372,6 +1372,13 @@ $ <userinput>kill -INT `head -1 /usr/local/pgsql/data/postmaster.pid`</userinput well. </para> </important> + + <para> + To terminate a session while allowing other sessions to continue, use + <function>pg_terminate_backend()</> (<xref + linkend="functions-admin-signal-table">) rather than sending a signal + to the child process. + </para> </sect1> <sect1 id="preventing-server-spoofing"> |