| From: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com> |
| Subject: | Re: Add explicit warnings about unsafe OAuth trace output for libpq |
| Date: | 2026-06-13 19:34:57 |
| Message-ID: | CAN4CZFNP9+UxPk861mbdG+q=Q__fR2UVvTdc_654w7S9WCQ9Dw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello
I have re-attached the same patches with simplified commit messages,
and I also marked the PG18 version with nocfbot so the master version
can apply correctly.
On Tue, Apr 7, 2026 at 7:28 PM Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> wrote:
>
> Hello
>
> This is based on earlier messages in the thread about OAUTHDEBUG splitting[1]:
>
> >> With the same logic, shouldn't we print a very visible warning when
> >> somebody enables trace? Since it's a long output, maybe to both the
> >> beginning and end of the flow?
> >
> > I'm more than happy to strengthen this as well, but let's kick that
> > out to its own thread, especially if pieces are backpatchable.
>
> The documentation already mentions that this option is unsafe because
> it prints out the HTTP traffic as-is, including secrets, but the
> output itself lacks a warning about it.
>
> Because the output is long, users might not notice that copy-pasting
> it or saving it to disk will share sensitive information. To increase
> visibility, this patch adds a warning to both the beginning and the
> end of the output.
>
> I also attached a version for 18, since this seems to be a useful
> change to backport. With the recent changes this is slightly different
> on 19.
>
> [1]: https://www.postgresql.org/message-id/CAOYmi%2Bkfw76zPa-tZPNs4KjxwthGLkQfpGyoKzMMy8_oNJz4DQ%40mail.gmail.com
| Attachment | Content-Type | Size |
|---|---|---|
| rel18-0001-libpq-oauth-Warn-when-PGOAUTHDEBUG-trace-may-expose-.nocfbot.patch | application/octet-stream | 1.5 KB |
| 0001-libpq-oauth-Warn-when-PGOAUTHDEBUG-trace-may-expose-.patch | application/octet-stream | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikita Malakhov | 2026-06-13 19:43:17 | Re: [(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table |
| Previous Message | Zsolt Parragi | 2026-06-13 19:30:01 | Re: Bug? pg_rewind produces unusable but starting database with standby recovery |