Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdoH1-0019eK-H3 for pgsql-admin@arkaria.postgresql.org; Tue, 13 Aug 2024 09:57:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sdoH0-002sxu-9H for pgsql-admin@arkaria.postgresql.org; Tue, 13 Aug 2024 09:57:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdoGz-002sxm-My for pgsql-admin@lists.postgresql.org; Tue, 13 Aug 2024 09:57:01 +0000 Received: from mailout3.izum.si ([193.2.126.3]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdoGw-004WJh-6I for pgsql-admin@lists.postgresql.org; Tue, 13 Aug 2024 09:57:00 +0000 Received: from EXSRV-01.izum.pri (EXSRV-01.izum.pri [10.1.100.193]) by mailout3.izum.si (Postfix) with ESMTPS id 6A86F6028606 for ; Tue, 13 Aug 2024 11:56:54 +0200 (CEST) DKIM-Filter: OpenDKIM Filter v2.11.0 mailout3.izum.si 6A86F6028606 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=izum.si; s=20210129; t=1723543014; bh=c+d3UM9qVEgpq4XLftM81hOQIf7y6RS6fDWEADkisSE=; h=From:To:Subject:Date:From; b=qWmJEXLv/cvN/oHRR/BFY58SYebUMgiGs/Kt0wthSff3LYU7zDrGhpVK1lsrt2OBB aBG3S8pp38iQ5e50E8sSf2Ursl9nXW3qCBmgGxQ763DUAAYnkIrpkNIO96fhv6f5cr cV4ST2m/SHpY7H2nmC6uUT6xvIRWVTJFCcBHl6eTx9SbVImtcZWK8hZtHeYOY3eDuM 8H9H3DdLU7ML7M91RGl/B1eoN23VL9hnkt13eGExokzdQX2y7hHgX7G47JtNYH9XXU w+GUUx2Hjwehu6M0/P6Tq9I28sLNXdr6O/IPcaklX784vAK1/B9vA/9ZABG0mJYqP6 htGVA4UpotroA== Received: from EXSRV-02.izum.pri (10.1.100.197) by EXSRV-01.izum.pri (10.1.100.193) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2507.34; Tue, 13 Aug 2024 11:56:54 +0200 Received: from EXSRV-02.izum.pri ([fe80::f170:99d6:d141:23e6]) by EXSRV-02.izum.pri ([fe80::f170:99d6:d141:23e6%8]) with mapi id 15.01.2507.034; Tue, 13 Aug 2024 11:56:54 +0200 From: =?iso-8859-2?Q?Domen_=A9etar?= To: "pgsql-admin@lists.postgresql.org" Subject: Function problem Thread-Topic: Function problem Thread-Index: AdrtZjLm8JNhKQd8T12XnUNwg7wNnw== Date: Tue, 13 Aug 2024 09:56:53 +0000 Message-ID: Accept-Language: sl-SI, en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [10.1.100.6] Content-Type: multipart/related; boundary="_004_e752541eb2524cdb86a83c76eb4d67ddizumsi_"; type="multipart/alternative" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_004_e752541eb2524cdb86a83c76eb4d67ddizumsi_ Content-Type: multipart/alternative; boundary="_000_e752541eb2524cdb86a83c76eb4d67ddizumsi_" --_000_e752541eb2524cdb86a83c76eb4d67ddizumsi_ Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi Admins I'm using pgbouncer in my postgresql installation. For authorization purpos= ese I use function public.lookup (https://www.cybertec-postgresql.com/en/pg= bouncer-authentication-made-easy/) which is defined for each database. Si= nce we upgraded postgresql from V14 to V16 I have problems when migrating d= atabase from one instance to another: authentication doesn't work. I have = to drop function and define it again on database to make authentication wor= k. Any idea why ? Best regards! [izum] Domen =A9etar Computer Systems Support IZUM - Institute of Information Science | Pre=B9ernova ulica 17 | 2000 Mari= bor | Slovenia T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si = | domen.setar@izum.si --_000_e752541eb2524cdb86a83c76eb4d67ddizumsi_ Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

Hi Admins

 

I’m using pgbouncer in my postgr= esql 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 defi= ne it again on database to make authentication work.  Any idea why ?

 

Best regards!

3D"izum=

Domen =A9etar
Computer Systems Support
IZUM ̵= 1; Institute of Information Science | Pre=B9er= nova ulica 17 | 2000 Maribor | Slovenia
T: = 3;386 2 25 20 339 | M: += 386 41 676 342 | www.izum.si | domen.setar@izum.si

 

 

--_000_e752541eb2524cdb86a83c76eb4d67ddizumsi_-- --_004_e752541eb2524cdb86a83c76eb4d67ddizumsi_ Content-Type: image/jpeg; name="image002.jpg" Content-Description: image002.jpg Content-Disposition: inline; filename="image002.jpg"; size=1318; creation-date="Tue, 13 Aug 2024 09:56:53 GMT"; modification-date="Tue, 13 Aug 2024 09:56:53 GMT" Content-ID: Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABHAEcDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gArN1OR0vdIVXZVe8ZXAONw8mU4P4gH8K0qwvE2q6ZoqaZfarctbwJeYVwpYbjFIOcc4xn8cVUU2 7ImTsrhqU0qaN4idZXVokk8tg2Cn7hTx6c81uD7o+lcFf+PfBsmmarF/bYb7Wj5VInLDMYTAyME8 frXer90fSnKLjuhRkm9GLRRRUFhRRRQAUUUUAFZev2Oj32lsuuR2z2UbCQm4ICoR0OT06n8zWpXJ +PNP07VLPSbTVGuBbPqAOLeMuxYQykAgAnHHPB/qLp/EiZ/Czj4brw1f6odK0bwvDr1swMc1zBYR QtDkdfMwqnrx936mvWx0rjfsNg2lyaZa6tqNlDLG0KD7KIUXcMDnylA6+oNdkOgqqruyKSsLRRRW RqFFFFABRRRQAVz3i7XZfD9pYXUOmy6g0l2IjDCu6QAxyElR6jb+Wa6Guc8Y3mtWVnp76FFDPeNd 4MMuMSIIpGKg9j8vXIq6avJJkVHaLOavfGer67ZT6VY+DtWjmvI2g827iMccYYbdzHHQZzivRYlZ YkVm3MFAJ9TXn8vjKDxFoGoJaXVzo2v2MDym0lO1wyrkjBGHHHpkegzXoQ+6PpV1VbS1iaevW4tF FFYmoUUUUAFFFFABXM+NLvTLG00y51S/ubCOO+UxXMAB2P5cn3gVbKkbh07iumrG1+ysNQfS7XUL NLqJ7w7UkAKhhDKckEHdxnj1IParhZS1Jnfl0OB8X6v8O/Etg8lxqii+ijJiuIImEuQOn3QDn0P6 V6sv3R9K4/UfDfhhdJ1iQ+HNPH2WJwfLgRWOIw3DbflPOM9sZrsB0FVUlFpKN/mRTi022LRRRWRq FFFFABRRRQAVmar/AMf+i/8AX63/AKImooprcUtilqv/ACA/E/8A1zk/9J1rfHQUUU3sJbi0UUVJ QUUUUAf/2Q== --_004_e752541eb2524cdb86a83c76eb4d67ddizumsi_--