Re: How to know killed by pg_terminate_backend - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: How to know killed by pg_terminate_backend
Date
Msg-id 4BEB9D22.6070503@enterprisedb.com
Whole thread Raw
In response to How to know killed by pg_terminate_backend  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: How to know killed by pg_terminate_backend
List pgsql-hackers
Tatsuo Ishii wrote:
> If a backend killed by pg_terminate_backend(), the backend returns
> 57P01 which is identical to the one when it's killed by postmaster.
> 
> Problem is, pgpool-II needs to trigger failover if postmaster goes
> down because apparently pgpool-II cannot use the PostgreSQL server
> anymore.
> 
> On the otherhand, pg_terminate_backend() just terminates a backend. So
> triggering failover is overkill.
> 
> Maybe we could make PostgreSQL a little bit smarter so that it returns
> a different code than 57P01 when killed by pg_terminate_backend().

Seems reasonable. Does the victim backend currently know why it has been
killed?

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: pg_upgrade code questions
Next
From: Peter Eisentraut
Date:
Subject: Re: Tags missing from GIT mirror?