Re: restart_after_crash

"Brandl, Wolfgang" <wolfgang.brandl@brz.gv.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.consulting@comcast.net
p: 312.241.7800