Function problem - Mailing list pgsql-admin

From Domen Šetar
Subject Function problem
Date
Msg-id e752541eb2524cdb86a83c76eb4d67dd@izum.si
Whole thread Raw
Responses Re: Function problem
Re: Function problem
List pgsql-admin

Hi Admins

 

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!

izum

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

 

 

Attachment

pgsql-admin by date:

Previous
From: Muhammad Imtiaz
Date:
Subject: Re: Pg_repack
Next
From: Ron Johnson
Date:
Subject: Re: pg_dump