Re: Things I don't like about \du's "Attributes" column

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jim Nasby <jim(dot)nasby(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Things I don't like about \du's "Attributes" column
Date: 2024-02-16 21:37:53
Message-ID: CAKFQuwbOM1L0v6BP2qOybY=ZS08jS_D4oONLUET_9-ZNikGoLQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 12, 2024 at 2:29 PM Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>
wrote:

> regress_du_role1 | no | Inherit | no | 2024-12-31 00:00:00+03(invalid) | 50 | Group role without password but with valid until
> regress_du_role2 | yes | Inherit | yes | | Not allowed | No connections allowed
> regress_du_role3 | yes | | yes | | 10 | User without attributes
> regress_du_su | yes | Superuser +| yes | | 3(ignored) | Superuser but with connection limit
>
>
Per the recent bug report, we should probably add something like (ignored)
after the 50 connections for role1 since they are not allowed to login so
the value is indeed ignored. It is ignored to zero as opposed to unlimited
for the Superuser so maybe a different word (not allowed)?

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-02-16 21:44:50 Re: Things I don't like about \du's "Attributes" column
Previous Message Andres Freund 2024-02-16 21:02:20 Re: System username in pg_stat_activity