Prestop hook for pgbouncer deployment.

[Harif-Rahman]

Can someone recommend the prestop command for pgbouncer?

i tried issue pause command and as we know that it will try to close all existing connection.
i sleep for 40 s and since my timeout is 30s i am expecting that all the queries are finished within 30s.
but lets say the new query is going to be executed for the old connection and since its in pause it will get timeout right.
how to handle this case ?

[JelteF]

This PR is meant to improve that situation: #902

[Harif-Rahman]

Can you give me example code template for this ?

[Harif-Rahman]

@JelteF

[JelteF]

Right now these changes are not released yet, so there isn't really example code. If you want to try out the PR and see if it indeed solves your issue, that would be useful though.