Обсуждение: oauth support?
Hello, I'm reading about the new OAuth support in PostgreSQL 18. It says PostgreSQL needs to be built using "--with-libcurl". In the PostgreSQL I get when using apt.postgresql.org, I don't see anything about curl in output from "ldd /usr/lib/postgresql/18/bin/postgres", nor from "ldd /usr/lib/postgresql/18/bin/psql". Should I expect to be able to use the new OAuth feature in PostgreSQL 18 with the packages from apt.postgresql.org? If so: Do I need to install a particular, extra package for it to be available? Thanks for providing APT repos of PostgreSQL. -- Troels
Re: Troels Arvin > Should I expect to be able to use the new OAuth feature in PostgreSQL 18 > with the packages from apt.postgresql.org? If so: Do I need to install a > particular, extra package for it to be available? Yes, libpq-oauth. Christoph
Hi, On Wed, 2025-12-10 at 08:40 +0100, Troels Arvin wrote: > I'm reading about the new OAuth support in PostgreSQL 18. It says > PostgreSQL needs to be built using "--with-libcurl". > > In the PostgreSQL I get when using apt.postgresql.org, I don't see > anything about curl in output from "ldd > /usr/lib/postgresql/18/bin/postgres", nor from "ldd > /usr/lib/postgresql/18/bin/psql". > > Should I expect to be able to use the new OAuth feature in PostgreSQL > 18 with the packages from apt.postgresql.org? If so: Do I need to > install a particular, extra package for it to be available? OAuth support is in the libpq-oauth (sub)package. RPMs also split that into -libs-oauth subpackage for security concerns over curl. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor BlueSky: @devrim.gunduz.org , @gunduz.org
Вложения
On 10/12/25 8:45, Devrim Gündüz wrote:
Hi, On Wed, 2025-12-10 at 08:40 +0100, Troels Arvin wrote:I'm reading about the new OAuth support in PostgreSQL 18. It says PostgreSQL needs to be built using "--with-libcurl". In the PostgreSQL I get when using apt.postgresql.org, I don't see anything about curl in output from "ldd /usr/lib/postgresql/18/bin/postgres", nor from "ldd /usr/lib/postgresql/18/bin/psql". Should I expect to be able to use the new OAuth feature in PostgreSQL 18 with the packages from apt.postgresql.org? If so: Do I need to install a particular, extra package for it to be available?OAuth support is in the libpq-oauth (sub)package. RPMs also split that into -libs-oauth subpackage for security concerns over curl. Regards,
Hi.
From what I can see, the package libpq-oauth contains the file:
/usr/lib/x86_64-linux-gnu/libpq-oauth-18.so
which is dynamically loaded by Postgres, see https://github.com/postgres/postgres/blob/master/src/interfaces/libpq/fe-auth-oauth.c#L818
WRT libcurl, it's not linked but shows in pg_config:
$ pg_config |grep -o "with-libcurl"
with-libcurl
Regards,
Álvaro
-- Alvaro Hernandez ----------- OnGres