Re: Reset Postgresql users password

You can also just write an sql and execute it, like:

select 'alter user '|| usename ||' with password ''newpassword'';' from
pg_user;
\gexec

Cheers,
Mateusz

śr., 12 lip 2023 o 21:35 Gianni Ceccarelli <dakkar(at)thenautilus(dot)net>
napisał(a):

> On 2023-07-12 Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com> wrote:
> > I wish to find out if there is a way to reset all users in Postgresql
> > password to the same password at once.
>
> I guess you could update the `pg_catalog.pg_authid` table, see
> https://www.postgresql.org/docs/15/catalog-pg-authid.html
>
> --
> Dakkar - <Mobilis in mobile>
> GPG public key fingerprint = A071 E618 DD2C 5901 9574
> 6FE2 40EA 9883 7519 3F88
> key id = 0x75193F88
>
>
>
>