public inbox for [email protected]  
help / color / mirror / Atom feed
From: Peter Eisentraut <[email protected]>
To: [email protected]
Subject: pgsql: dblink: SCRAM authentication pass-through
Date: Wed, 26 Mar 2025 09:49:48 +0000
Message-ID: <[email protected]> (raw)

dblink: SCRAM authentication pass-through

This enables SCRAM authentication for dblink (using dblink_fdw) when
connecting to a foreign server without having to store a plain-text
password on user mapping options

This uses the same approach as it was implemented for postgres_fdw in
commit 761c79508e7.  (It also contains the equivalent of the
subsequent fixes 76563f88cfb and d2028e9bbc1.)

Author: Matheus Alcantara <[email protected]>
Reviewed-by: Jacob Champion <[email protected]>
Discussion: https://www.postgresql.org/message-id/flat/CAFY6G8ercA1KES%3DE_0__R9QCTR805TTyYr1No8qF8ZxmMg8z2Q%40m...

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3642df265d09779443a9f44f5cb873df40974e89

Modified Files
--------------
contrib/dblink/Makefile            |   1 +
contrib/dblink/dblink.c            | 184 ++++++++++++++++++++++++++-
contrib/dblink/meson.build         |   5 +
contrib/dblink/t/001_auth_scram.pl | 254 +++++++++++++++++++++++++++++++++++++
doc/src/sgml/dblink.sgml           |  21 ++-
doc/src/sgml/postgres-fdw.sgml     |   4 +-
6 files changed, 457 insertions(+), 12 deletions(-)



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]
  Subject: Re: pgsql: dblink: SCRAM authentication pass-through
  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