Re: rebellious pg stats collector (reopened case)

Laszlo Nagy írta:
>
>> 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)
>>
Sorry for coming back so late. I changed this, and reinstalled
postgresql but it won't start. Some messages from the log:


Jan  8 00:40:29 shopzeus postgres[80522]: [3814-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:30 shopzeus postgres[80559]: [3849-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:30 shopzeus postgres[80632]: [3917-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:31 shopzeus postgres[80662]: [3946-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:31 shopzeus postgres[80700]: [3981-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:31 shopzeus postgres[80734]: [4014-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:31 shopzeus postgres[80738]: [4017-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:32 shopzeus postgres[80768]: [4046-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:32 shopzeus postgres[80802]: [4078-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:32 shopzeus postgres[80806]: [4079-1] WARNING:  terminating
connection because of crash of another server process
Jan  8 00:40:32 shopzeus postgres[80806]: [4079-2] DETAIL:  The
postmaster has commanded this server process to roll back the current
transaction and exit, because another server
Jan  8 00:40:32 shopzeus postgres[80806]: [4079-3]  process exited
abnormally and possibly corrupted shared memory.
Jan  8 00:40:32 shopzeus postgres[80806]: [4079-4] HINT:  In a moment
you should be able to reconnect to the database and repeat your command.
Jan  8 00:40:32 shopzeus postgres[80835]: [4109-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:32 shopzeus postgres[80837]: [4110-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:33 shopzeus postgres[80870]: [4141-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:33 shopzeus postgres[80900]: [4170-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:34 shopzeus postgres[80938]: [4205-1] FATAL:  the database
system is in recovery mode
Jan  8 00:40:34 shopzeus postgres[80967]: [4233-1] FATAL:  the database
system is in recovery mode

(I had to reinstall the original version because it will be used today.)