44 #define SIGNAL_BACKEND_SUCCESS 0
45 #define SIGNAL_BACKEND_ERROR 1
46 #define SIGNAL_BACKEND_NOPERMISSION 2
47 #define SIGNAL_BACKEND_NOSUPERUSER 3
72 (
errmsg(
"PID %d is not a PostgreSQL backend process", pid)));
104 (
errmsg(
"could not send signal to process %d: %m", pid)));
123 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
124 errmsg(
"permission denied to cancel query"),
125 errdetail(
"Only roles with the %s attribute may cancel queries of roles with %s.",
126 "SUPERUSER",
"SUPERUSER")));
130 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
131 errmsg(
"permission denied to cancel query"),
132 errdetail(
"Only roles with privileges of the role whose query is being canceled or with privileges of the \"%s\" role may cancel this query.",
133 "pg_signal_backend")));
149 int64 waittime = 100;
154 int64 remainingtime = timeout;
164 if (remainingtime < waittime)
165 waittime = remainingtime;
167 if (
kill(pid, 0) == -1)
173 (
errcode(ERRCODE_INTERNAL_ERROR),
174 errmsg(
"could not check the existence of the backend with PID %d: %m",
188 remainingtime -= waittime;
189 }
while (remainingtime > 0);
192 (
errmsg_plural(
"backend with PID %d did not terminate within %lld millisecond",
193 "backend with PID %d did not terminate within %lld milliseconds",
195 pid, (
long long int) timeout)));
222 (
errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE),
223 errmsg(
"\"timeout\" must not be negative")));
229 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
230 errmsg(
"permission denied to terminate process"),
231 errdetail(
"Only roles with the %s attribute may terminate processes of roles with %s.",
232 "SUPERUSER",
"SUPERUSER")));
236 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
237 errmsg(
"permission denied to terminate process"),
238 errdetail(
"Only roles with privileges of the role whose process is being terminated or with privileges of the \"%s\" role may terminate this process.",
239 "pg_signal_backend")));
260 (
errmsg(
"failed to send signal to postmaster: %m")));
278 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
279 errmsg(
"must be superuser to rotate log files with adminpack 1.0"),
281 errhint(
"Consider using %s, which is part of core, instead.",
282 "pg_logfile_rotate()")));
287 (
errmsg(
"rotation not possible because log collection not active")));
307 (
errmsg(
"rotation not possible because log collection not active")));
bool has_privs_of_role(Oid member, Oid role)
int errmsg_plural(const char *fmt_singular, const char *fmt_plural, unsigned long n,...)
int errdetail(const char *fmt,...)
int errhint(const char *fmt,...)
int errcode(int sqlerrcode)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
#define PG_GETARG_INT64(n)
#define PG_GETARG_INT32(n)
#define PG_RETURN_BOOL(x)
void ResetLatch(Latch *latch)
int WaitLatch(Latch *latch, int wakeEvents, long timeout, uint32 wait_event_info)
#define WL_EXIT_ON_PM_DEATH
#define CHECK_FOR_INTERRUPTS()
void SendPostmasterSignal(PMSignalReason reason)
@ PMSIGNAL_ROTATE_LOGFILE
PGPROC * BackendPidGetProc(int pid)
static int pg_signal_backend(int pid, int sig)
Datum pg_cancel_backend(PG_FUNCTION_ARGS)
#define SIGNAL_BACKEND_SUCCESS
#define SIGNAL_BACKEND_NOPERMISSION
Datum pg_rotate_logfile_v2(PG_FUNCTION_ARGS)
Datum pg_rotate_logfile(PG_FUNCTION_ARGS)
#define SIGNAL_BACKEND_NOSUPERUSER
Datum pg_reload_conf(PG_FUNCTION_ARGS)
Datum pg_terminate_backend(PG_FUNCTION_ARGS)
#define SIGNAL_BACKEND_ERROR
static bool pg_wait_until_termination(int pid, int64 timeout)
bool superuser_arg(Oid roleid)
@ WAIT_EVENT_BACKEND_TERMINATION