<literal><function>pg_terminate_backend(<parameter>pid</parameter> <type>int</>)</function></literal>

</entry>

<entry><type>boolean</type></entry>

<entry>Terminate a backend</entry>

<entry>Terminate a backend. You can execute this against

another backend that has exactly the same role as the user

calling the function. In all other cases, you must be a

superuser.

</entry>

</row>

</tbody>

</tgroup>

<command>postgres</command> processes on the server (using

<application>ps</> on Unix or the <application>Task

Manager</> on <productname>Windows</>).

For the less restrictive <function>pg_cancel_backend</>, the role of an

active backend can be found from

the <structfield>usename</structfield> column of the

The role of an active backend can be found from the

<structfield>usename</structfield> column of the

<structname>pg_stat_activity</structname> view.

</para>

</para>

<para>

<function>pg_cancel_backend()</> will work on user backends, but not the

Startup process, which performs recovery. <structname>pg_stat_activity</structname> does not

show an entry for the Startup process, nor do recovering transactions

show as active. As a result, <structname>pg_prepared_xacts</structname> is always empty during

recovery. If you wish to resolve in-doubt prepared transactions,

view <literal>pg_prepared_xacts</> on the primary and issue commands to

resolve transactions there.

<function>pg_cancel_backend()</>

and <function>pg_terminate_backend()</> will work on user backends,

but not the Startup process, which performs

recovery. <structname>pg_stat_activity</structname> does not show an

entry for the Startup process, nor do recovering transactions show

as active. As a result, <structname>pg_prepared_xacts</structname>

is always empty during recovery. If you wish to resolve in-doubt

prepared transactions, view <literal>pg_prepared_xacts</> on the

primary and issue commands to resolve transactions there.

</para>

<para>

}

pg_terminate_backend(PG_FUNCTION_ARGS)

{

if (!superuser())

intr=pg_signal_backend(PG_GETARG_INT32(0),SIGTERM);

if (r==SIGNAL_BACKEND_NOPERMISSION)

ereport(ERROR,

(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),

errmsg("must be superuser to terminate other server processes"),

errhint("You can cancel your own processes with pg_cancel_backend().")));

(errmsg("must be superuser or have the same role to terminate backends running in other server processes"))));

PG_RETURN_BOOL(pg_signal_backend(PG_GETARG_INT32(0),SIGTERM)==SIGNAL_BACKEND_SUCCESS);

PG_RETURN_BOOL(r==SIGNAL_BACKEND_SUCCESS);

}