Re: Reset Postgresql users password

[Wen Yi]

I think maybe you can check the pg_hba.conf, change the method to the 'trust'.
(Allow the connection unconditionally. This method allows anyone that can 
connect to the PostgreSQL database server to login as any PostgreSQL user they 
wish, without the need for a password or any other authentication. See 
Section 21.4 for details.)



And then login as the root user, after that do the things you wish.



https://www.postgresql.org/docs/current/auth-pg-hba-conf.html





------------------ Original ------------------
From:                                                                           
                                             "Ron"                              
                                                      
<ronljohnso...@gmail.com&gt;;
Date:&nbsp;Mon, Jul 17, 2023 10:28 AM
To:&nbsp;"pgsql-general"<pgsql-general@lists.postgresql.org&gt;;

Subject:&nbsp;Re: Reset Postgresql users password



On 7/12/23 14:28, Johnathan Tiamoh wrote:
&gt; Hello,
&gt;
&gt; I wish to find out if there is a way to reset all users in Postgresql 
&gt; password to the same password at once.

To the same value??

-- 
Born in Arizona, moved to Babylonia.