From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Laszlo Nagy <gandalf(at)shopzeus(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: rebellious pg stats collector (reopened case) |
Date: | 2008-12-29 15:26:33 |
Message-ID: | 7721.1230564393@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
Laszlo Nagy <gandalf(at)shopzeus(dot)com> writes:
> maybe is it possible to change the source code, and disable the "is
> postmaster alive" check for testing?
Rather than disabling it, it'd probably be more convenient to make
any getppid value except 1 (the init process) be treated as "it's
alive". Otherwise you'll have trouble with the collector not stopping
when you want it to. Look into src/backend/storage/ipc/pmsignal.c:
- return (getppid() == PostmasterPid);
+ return (getppid() != 1);
(Obviously this is a hack, but it should work on any Unixish system)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Carol Walter | 2008-12-29 21:23:30 | ssl database connection problems... |
Previous Message | Laszlo Nagy | 2008-12-29 08:06:51 | Re: rebellious pg stats collector (reopened case) |
From | Date | Subject | |
---|---|---|---|
Next Message | Laszlo Nagy | 2008-12-30 09:05:59 | Big index sizes |
Previous Message | Laszlo Nagy | 2008-12-29 13:11:48 | Re: Slow table update - SOLVED! |