postgresql - how to restrict specific hosts from connecting to pgbouncer? -

i running postgres-9.2 on 6432 port , pgbouncer on 5432 port. few of colleagues client machines have firewall connection permissions on 5432 port on server machine. db admin, wanted restrict ip addresses accessing database.

but, though block in pg_hba.conf file, since pgbouncer port allowed, able access.

i can block @ os firewall level don't want take of system administrator. so, there way restrict , deny ip addresses accessing pgbouncer through pg_hba.conf postgresql.

please suggest.

https://pgbouncer.github.io/2015/12/pgbouncer-1-7

main changes v1.6 support tls connections, hba control file , authentication via unix peer uid.

so 1.7 have hba file, in vanil postgres. , filtering connections ip easy.

also can use tricks, dropping connections after connected, described in other recent answer https://stackoverflow.com/a/46191949/5315974 again - more trick urgently getting rid of connections. using such tricks in while loop or job bad idea.