Re: restart_after_crash

"Brandl, Wolfgang" <wolfgang(dot)brandl(at)brz(dot)gv(dot)at> writes:

> Hi
> We are testing
> restart_after_crash = on
>
> What is a cras? We killed the Postgres process with -9 SIGSEGV SIGABRT etc.. But never postgres is restarting.
>
> The question arose because of the decision to restart Postgres over systemctl or with the Postgres feature.
>
> But it seems that the Postgres restart is not working or not always working. Or is an additional feature necessary?

It is for a postmaster controlled kill of all backends after a *backend*
crash.

Killing postmaster itself as you are doing does not invoke the feature.

Try choosing any client backend by PID and then do your kill -9 on that
one.

Then expect any other backends to be killed also but the postmaster
still working and then spawning more backend when clients attempt to
connect.

>
> Regards
> Wolfgang

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800