Postgres Pro
Downloads
Home   >   mailing lists

Re: Reset Postgresql users password - Mailing list pgsql-general

From Mateusz Henicz
Subject Re: Reset Postgresql users password
Date
Msg-id CAN6i3YNXg=YCx7Qea-5hhY-JsgA+SzULqNFwHTsoGXUaSZ6qHQ@mail.gmail.com
Whole thread Raw
In response to Re: Reset Postgresql users password  (Gianni Ceccarelli <dakkar@thenautilus.net>)
Responses Re: Reset Postgresql users password
List pgsql-general
Tree view
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@thenautilus.net> napisał(a):
On 2023-07-12 Johnathan Tiamoh <johnathantiamoh@gmail.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



pgsql-general by date:

Previous
From: Gianni Ceccarelli
Date:
Subject: Re: Reset Postgresql users password
Next
From: Gurjeet Singh
Date:
Subject: Re: Reset Postgresql users password