org/wiki/Todo 8 https://www.postgresql.org xxxvii Preface • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample GRANT, with noted exceptions. Each of these functions returns true if the signal was successfully sent and false if sending the signal failed. Table 9.86. Server Signaling Functions Function Description is a member of the role whose backend is being can- celed or the calling role has been granted pg_signal_backend, however only superusers can cancel superuser backends. pg_log_backend_memory_contexts

include, but is not limited to, the following circumstances: • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample GRANT, with noted exceptions. Each of these functions returns true if the signal was successfully sent and false if sending the signal failed. Table 9.86. Server Signaling Functions Function Description is a member of the role whose backend is be- ing canceled or the calling role has been granted pg_signal_backend, however only superusers can cancel superuser backends. pg_log_backend_memory_contexts

postgresql.org/wiki/Todo 8 https://www.postgresql.org xxxvi Preface • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample role is a member of the role whose backend is being canceled or the calling role has been granted pg_signal_backend, how- ever only superusers can cancel superuser backends. pg_reload_conf() boolean Cause is a member of the role whose backend is being terminated or the calling role has been granted pg_signal_backend, how- ever only superusers can termi- nate superuser backends. Each of these functions returns

postgresql.org/wiki/Todo 8 https://www.postgresql.org xxxvi Preface • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample is a member of the role whose backend is being can- celed or the calling role has been granted pg_signal_backend, however only superusers can cancel superuser backends. pg_reload_conf () → boolean Causes the PostgreSQL server to reload their configuration files. (This is ini- tiated by sending a SIGHUP signal to the postmaster process, which in turn sends SIGHUP to each of its children.) pg_rotate_logfile

include, but is not limited to, the following circumstances: • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample is a member of the role whose backend is be- ing canceled or the calling role has been granted pg_signal_backend, however only superusers can cancel superuser backends. pg_reload_conf () → boolean Causes the PostgreSQL server to reload their configuration files. (This is initiated by sending a SIGHUP signal to the postmaster process, which in turn sends SIGHUP to each of its children.) pg_rotate_logfile

include, but is not limited to, the following circumstances: • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample is a member of the role whose backend is being terminated or the calling role has been granted pg_signal_backend, how- ever only superusers can termi- nate superuser backends. Each of these functions returns can be found from the usename column of the pg_stat_activity view. pg_reload_conf sends a SIGHUP signal to the server, causing configuration files to be reloaded by all server processes. pg_rotate_logfile

org/wiki/Todo 8 https://www.postgresql.org xxxvii Preface • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample GRANT, with noted exceptions. Each of these functions returns true if the signal was successfully sent and false if sending the signal failed. Table 9.90. Server Signaling Functions Function Description is a member of the role whose backend is being can- celed or the calling role has privileges of pg_signal_backend, however only superusers can cancel superuser backends. pg_log_backend_memory_contexts

include, but is not limited to, the following circumstances: • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample GRANT, with noted exceptions. Each of these functions returns true if the signal was successfully sent and false if sending the signal failed. Table 9.90. Server Signaling Functions Function Description is a member of the role whose backend is be- ing canceled or the calling role has privileges of pg_signal_backend, however only superusers can cancel superuser backends. pg_log_backend_memory_contexts

include, but is not limited to, the following circumstances: • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample returns true if successful and false otherwise. pg_cancel_backend sends a query cancel (SIGINT) signal to a backend process identified by process ID. The process ID of an active backend can be found from view, or by listing the postgres processes on the server with ps. pg_reload_conf sends a SIGHUP signal to the postmaster, causing the configuration files to be reloaded by all server processes. pg_rotate_logfile

org/wiki/Todo 8 https://www.postgresql.org xxxvii Preface • A program terminates with a fatal signal or an operating system error message that would point to a problem in the program. (A counterexample GRANT, with noted exceptions. Each of these functions returns true if the signal was successfully sent and false if sending the signal failed. 436 Functions and Operators Table 9.94. Server Signaling Functions is a member of the role whose backend is being can- celed or the calling role has privileges of pg_signal_backend, however only superusers can cancel superuser backends. pg_log_backend_memory_contexts