pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedrestart_after_crash
3+ messages / 3 participants
[nested] [flat]
* restart_after_crash
@ 2018-09-12 07:52 Brandl, Wolfgang <wolfgang.brandl@brz.gv.at>
2018-09-12 08:20 ` Re: restart_after_crash Christoph Berg <myon@debian.org>
2018-09-12 14:43 ` Re: restart_after_crash Jerry Sievers <gsievers19@comcast.net>
0 siblings, 2 replies; 3+ messages in thread
From: Brandl, Wolfgang @ 2018-09-12 07:52 UTC (permalink / raw)
To: pgsql-admin
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?
Regards
Wolfgang
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: restart_after_crash
2018-09-12 07:52 restart_after_crash Brandl, Wolfgang <wolfgang.brandl@brz.gv.at>
@ 2018-09-12 08:20 ` Christoph Berg <myon@debian.org>
1 sibling, 0 replies; 3+ messages in thread
From: Christoph Berg @ 2018-09-12 08:20 UTC (permalink / raw)
To: Brandl, Wolfgang <wolfgang.brandl@brz.gv.at>; +Cc: pgsql-admin
Re: Brandl, Wolfgang 2018-09-12 <F2EB158D72DC6A4F97877DD0BB6F020E65065972@CMD0MBX-AB01.cmd0.cna.at>
> 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.
You need to kill a backend process. If you kill the postmaster, there
is nothing that could restart.
Christoph
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: restart_after_crash
2018-09-12 07:52 restart_after_crash Brandl, Wolfgang <wolfgang.brandl@brz.gv.at>
@ 2018-09-12 14:43 ` Jerry Sievers <gsievers19@comcast.net>
1 sibling, 0 replies; 3+ messages in thread
From: Jerry Sievers @ 2018-09-12 14:43 UTC (permalink / raw)
To: Brandl\, Wolfgang <wolfgang.brandl@brz.gv.at>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-09-12 14:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-09-12 07:52 restart_after_crash Brandl, Wolfgang <wolfgang.brandl@brz.gv.at>
2018-09-12 08:20 ` Christoph Berg <myon@debian.org>
2018-09-12 14:43 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox