NOTE: We are in the process of modifying the file structure and configuration for many Bitnami stacks. On account of these changes, the file paths stated in this guide may change depending on whether your Bitnami stack uses native Linux system packages (Approach A), or if it is a self-contained installation (Approach B). To identify your Bitnami installation type and what approach to follow, run the command below:

1. Mac Postgres Password Change
2. Forgot Postgres Password Mac
3. Mac Postgres Password Reset
4. Mac Postgres User Password

The output of the command indicates which approach (A or B) is used by the installation, and will allow you to identify the paths, configuration and commands to use in this guide. Refer to the FAQ for more information on these changes.

Brew install postgresql 但是好像还有另一种方法，就是使用官网提供的Postgres.app， 号称是：The easiest way to get started with PostgreSQL on the Mac。 看到这条口号，是不是有点心动，按照官网的提示来：. I am currently running postgres in a docker container for development purposes. I am able to connect to the container using psql from my mac by doing psql -h localhost -U someuser then typing the password. The password is the same as the username and it's a really simple password.

Mac Postgres Password Change

Change the PostgreSQL password

You can modify the PostgreSQL password using the following command at the shell prompt:

Reset the PostgreSQL password

If you don’t remember your PostgreSQL database password, you can follow the steps below to reset it to a new value:

• Change the authentication method in the PostgreSQL configuration file pg_hba.conf from md5 to trust and reload the configuration.

  • Approach A (Bitnami installations using system packages):

  • Approach B (Self-contained Bitnami installations):

• Connect to the PostgreSQL database and set the password to a new value:

• Finally, change the authentication method back to md5 and reload the old PostgreSQL configuration:

• Approach A (Bitnami installations using system packages):

  • Approach B (Self-contained Bitnami installations):

You should now be able to connect to PostgreSQL with the new password.

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing few steps for recovering the forgot password of postgres user (admin user) of PostgreSQL.

Yesterday, I was checking few forums of PostgreSQL and found that few DBAs forgot their password after installation of PostgreSQL.

The postgres user is a superuser of PostgreSQL, and it is a default user also. While installing PostgreSQL, you have to set the password of postgres user, and if you forget the password, you can’t do any operation like create first DB or create first DB User.

How to recover forgotten password of PostgreSQL?

Edit pg_hba.conf file:
Change below line for MD5 to TRUST

Restart the PostgreSQL Server:

Forgot Postgres Password Mac

Connect the PostgreSQL:

Change the password of postgres user:

Mac Postgres Password Reset

Last, rollback the change in pg_hba.conf file and restart the PostgreSQL Server:

Mac Postgres User Password