Once this is done, save the file and exit it. For more information, refer to the Postgres documentation here. You will see the md5 or scram-sha-256 method near the bottom of the file. Or, open the command line and enter the command below: sudo vim /Library/PostgreSQL/14/data/pg_hba.confĪfter opening the pg_hba.conf file with your text editor, change the "" scram-sha-256" method for all users to " trust.” The method may also say md5 - in which case, changing it to trust is still correct. Look for a file called pg_hba.conf in Finder and open it in the text editor. This file is located in the data directory of Postgres (the folder where you installed Postgres, for example: /PostgreSQL/14/data/). You can reset your Postgres 14 password by following the steps below: Step 1įirst, we’ll modify the pg_hba.conf file. In this guide, we'll walk you through the step-by-step process to reset your Postgres 14 password on a MacOS system. In either case, you’re not locked out forever. If you have Postgres 14 installed on your Mac, you may find that you need to change the password at some point - either for security reasons, or because you simply forgot it.
0 kommentar(er)
