public inbox for [email protected]  
help / color / mirror / Atom feed
oauth support?
4+ messages / 4 participants
[nested] [flat]

* oauth support?
@ 2025-12-10 07:40 Troels Arvin <[email protected]>
  2025-12-10 07:44 ` Re: oauth support? Christoph Berg <[email protected]>
  2025-12-10 07:45 ` Re: oauth support? Devrim Gündüz <[email protected]>
  0 siblings, 2 replies; 4+ messages in thread

From: Troels Arvin @ 2025-12-10 07:40 UTC (permalink / raw)
  To: [email protected]

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






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: oauth support?
  2025-12-10 07:40 oauth support? Troels Arvin <[email protected]>
@ 2025-12-10 07:44 ` Christoph Berg <[email protected]>
  1 sibling, 0 replies; 4+ messages in thread

From: Christoph Berg @ 2025-12-10 07:44 UTC (permalink / raw)
  To: Troels Arvin <[email protected]>; +Cc: [email protected]

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: oauth support?
  2025-12-10 07:40 oauth support? Troels Arvin <[email protected]>
@ 2025-12-10 07:45 ` Devrim Gündüz <[email protected]>
  2025-12-10 12:45   ` Re: oauth support? Álvaro Hernández <[email protected]>
  1 sibling, 1 reply; 4+ messages in thread

From: Devrim Gündüz @ 2025-12-10 07:45 UTC (permalink / raw)
  To: Troels Arvin <[email protected]>; [email protected]

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


Attachments:

  [application/pgp-signature] signature.asc (858B, 2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: oauth support?
  2025-12-10 07:40 oauth support? Troels Arvin <[email protected]>
  2025-12-10 07:45 ` Re: oauth support? Devrim Gündüz <[email protected]>
@ 2025-12-10 12:45   ` Álvaro Hernández <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Álvaro Hernández @ 2025-12-10 12:45 UTC (permalink / raw)
  To: Devrim Gündüz <[email protected]>; Troels Arvin <[email protected]>; [email protected]



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


^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2025-12-10 12:45 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-10 07:40 oauth support? Troels Arvin <[email protected]>
2025-12-10 07:44 ` Christoph Berg <[email protected]>
2025-12-10 07:45 ` Devrim Gündüz <[email protected]>
2025-12-10 12:45   ` Álvaro Hernández <[email protected]>

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