Re: How to know killed by pg_terminate_backend

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