| 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: | Whole Thread | Raw Message | 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! |