Re: rebellious pg stats collector (reopened case)

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

In response to

Responses

Browse pgsql-admin by date

  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)

Browse pgsql-performance by date

  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!