public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Domen Šetar <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Function problem
Date: Tue, 27 Aug 2024 06:37:01 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Tue, 2024-08-13 at 09:56 +0000, Domen Šetar wrote:
> 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 ?

I guess that my article is at fault.  It still refers to "md5" authentication rather than
"scram-sha-256", which has been the password authenticatoin method of choice for years now.

I have updated my article.

Yours,
Laurenz Albe

view thread (3+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Function problem
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox