diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 19 | ||||
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 10 |
2 files changed, 24 insertions, 5 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 23a758cd02e..7e120bc8621 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.432 2008/04/15 20:28:46 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.433 2008/04/17 20:56:41 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 signals (<systemitem>SIGINT</> or <systemitem>SIGTERM</> + respectively) to backend processes 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 eb9b937a818..63259faff5a 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.413 2008/04/15 20:28:46 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.414 2008/04/17 20:56:41 momjian Exp $ --> <chapter Id="runtime"> <title>Operating System Environment</title> @@ -1372,6 +1372,14 @@ $ <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">) or send a + <systemitem>SIGTERM</> signal to the child process associated with + the session. + </para> </sect1> <sect1 id="preventing-server-spoofing"> |