Postgres Pro
Downloads
Home   >   mailing lists

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

From Gianni Ceccarelli
Subject Re: Reset Postgresql users password
Date
Msg-id 20230712203446.19535e83@thenautilus.net
Whole thread Raw
In response to Reset Postgresql users password  (Johnathan Tiamoh <johnathantiamoh@gmail.com>)
Responses Re: Reset Postgresql users password  (Mateusz Henicz <mateuszhenicz@gmail.com>)
List pgsql-general
Tree view 
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: Johnathan Tiamoh
Date:
Subject: Reset Postgresql users password
Next
From: Mateusz Henicz
Date:
Subject: Re: Reset Postgresql users password