Heikki Linnakangas escribió:
> Zou Yong wrote:

>> I was running postgres on a Linux with busybox. The autovacuum feature is
>> turned on. I noticed that the autovacuum worker sent SIGUSR1 to pid 1 which
>> is the init process and caused the system halt.
>
> Hmm. The postgres user shouldn't have permission to halt the system,  
> methinks.

Yeah, the reason this hasn't ever been seen is that normally we don't
have permissions to signal init.  My guess is that Zou Yang is running a
system without users where everything runs as root.  This fits the fact
that it's running busybox: I guess it's an embedded system of some sort.

>> I did some debugging and found that the root cause is the constant
>> AutoVacNumSignals is not defined correctly. It should be (AutoVacRebalance +
>> 1).
>
> Yeah, that's clearly a bug. Fixed, thanks.

My fault.  Thanks for the patch.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to