Hook for Postgres server to run code when a DB connection is closed or lost?

Question

I need to run some code for cleaning up after a database connection is gracefully closed or rudely interrupted/lost. This clean-up cannot be handled within the scope of a transaction inside the connection. So the clean-up (modifying some records, etc.) must be handled on the server-side in PL/pgSQL or Java etc. after the connection is gone. The clean-up is critical, so it must be done reliably every time.

Is there a hook for code to be called on every connection closure/loss in the Postgres server?

Pavel Stehule · Accepted Answer · 2017-06-12 05:15:12Z

2

Theoretically you can write C extension and you can register your callback on shared memory cleaning. It is possible only in C extension. It is called every time - at session end - not only when connection is lost.

answered Jun 12, 2017 at 5:15

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hook for Postgres server to run code when a DB connection is closed or lost?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related