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(
"must be a superuser to cancel superuser query")));
128 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
129 errmsg(
"must be a member of the role whose query is being canceled or member of pg_signal_backend")));
145 int64 waittime = 100;
150 int64 remainingtime = timeout;
160 if (remainingtime < waittime)
161 waittime = remainingtime;
163 if (
kill(pid, 0) == -1)
169 (
errcode(ERRCODE_INTERNAL_ERROR),
170 errmsg(
"could not check the existence of the backend with PID %d: %m",
184 remainingtime -= waittime;
185 }
while (remainingtime > 0);
188 (
errmsg_plural(
"backend with PID %d did not terminate within %lld millisecond",
189 "backend with PID %d did not terminate within %lld milliseconds",
191 pid, (
long long int) timeout)));
218 (
errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE),
219 errmsg(
"\"timeout\" must not be negative")));
225 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
226 errmsg(
"must be a superuser to terminate superuser process")));
230 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
231 errmsg(
"must be a member of the role whose process is being terminated or member of pg_signal_backend")));
252 (
errmsg(
"failed to send signal to postmaster: %m")));
270 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
271 errmsg(
"must be superuser to rotate log files with adminpack 1.0"),
273 errhint(
"Consider using %s, which is part of core, instead.",
274 "pg_logfile_rotate()")));
279 (
errmsg(
"rotation not possible because log collection not active")));
299 (
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 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