I’m using pgbouncer in my postgresql installation. For authorization purposese I use function public.lookup (https://www.cybertec-postgresql.com/en/pgbouncer-authentication-made-easy/) which is defined for each database. Since we upgraded postgresql from V14 to V16 I have problems when migrating database from one instance to another: authentication doesn’t work. I have to drop function and define it again on database to make authentication work. Any idea why ?
Best regards!
Domen Šetar Computer Systems Support IZUM – Institute of Information Science| Prešernova ulica 17 | 2000 Maribor |Slovenia T: +386 2 25 20 339| M: +386 41 676 342| www.izum.si|domen.setar@izum.si