Re: got some errors after upgrade poestgresql from 9.5 to 9.6

thanks a lot , i also think so , and will check the ram and kernel configure ,and try again .

----- 原始邮件 -----
发件人: "Michael Paquier" <michael.paquier@gmail.com>
收件人: "Pavel Stehule" <pavel.stehule@gmail.com>
抄送: "张嘉志" <zhangjiazhi@p1.com>, pgsql-bugs@postgresql.org, "backend" <backend@p1.com>, "dba" <dba@p1.com>
发送时间: 星期三, 2016年 11 月 23日 下午 8:51:04
主题: Re: [BUGS] got some errors after upgrade poestgresql from 9.5 to 9.6

On Wed, Nov 23, 2016 at 8:58 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2016-11-23 12:49 GMT+01:00 张嘉志 <zhangjiazhi@p1.com>:
>> ===LOGS
>>
>> 2016-11-23 19:26:05.027 CST,,,7888,,58357a04.1ed0,3,,2016-11-23 19:14:12
>> CST,,0,LOG,00000,"server process (PID 7993) was terminated by signal 9:
>> Killed"
>
> It looks like somebody killed Postgres - Postgres doesn't use signal 9 what
> I know - probably someone did kill -9 on some PostgreSQL process.

This can be the OOM killer if the OS is Linux. The failure pattern
matches with what I would expect the OOM killer to do.
--
Michael