How to Reset PostgreSQL Password

Encountered a PostgreSQL password reset issue? This guide provides a straightforward solution, especially helpful for Windows users. Let's reset your PostgreSQL password in a few simple steps.

Step 1: Halt the PostgreSQL Service

Before resetting the password, stop the PostgreSQL service:

1. Press Win R, type services.msc, and press Enter.
2. Locate the PostgreSQL service.
3. Right-click and select Stop.

Step 2: Launch PostgreSQL in Single-User Mode

Start PostgreSQL in single-user mode for password reset without needing the current password:

1. Open Command Prompt as administrator (Win S, type cmd, right-click, and choose Run as administrator).
2. Navigate to the PostgreSQL bin directory (usually: cd "C:Program FilesPostgreSQL16bin". Adjust the path if necessary).
3. Execute this command: postgres --single -D "C:Program FilesPostgreSQL16data" postgres (Modify the data directory path if it differs from the default).

Step 3: Password Reset

The PostgreSQL single-user mode prompt allows SQL commands. Reset the postgres user password using:

<code class="language-sql">ALTER USER postgres WITH PASSWORD 'your_new_password';</code>

Replace 'your_new_password' with your desired password. Press Enter.

Step 4: Restart the PostgreSQL Service

Close the Command Prompt to exit single-user mode. Restart the PostgreSQL service via the Services tool (right-click PostgreSQL, select Start).

Step 5: Reconnect using pgAdmin

Open pgAdmin 4 (or your preferred PostgreSQL client) and connect using the new password. If connection fails, update the saved password in pgAdmin:

1. Right-click the server in the Object Browser.
2. Select Properties → Connection.
3. Input the new password and click Save.

Quick Steps Summary:

1. Stop PostgreSQL: Use services.msc to stop the service.
2. Admin Command Prompt: Open Command Prompt as administrator.
3. Navigate to PostgreSQL bin: Use cd "C:Program FilesPostgreSQL16bin" (adjust path as needed).
4. Single-User Mode: Run postgres --single -D "C:Program FilesPostgreSQL16data" postgres (adjust path as needed).
5. Reset Password: Use ALTER USER postgres WITH PASSWORD 'your_new_password';
6. Restart PostgreSQL: Restart the service in services.msc.
7. Reconnect with pgAdmin: Use the new password.

This guide simplifies PostgreSQL password resets on Windows, resolving database lockout issues.

---

Stay connected - @syedamaham.dev ?

The above is the detailed content of How to Reset PostgreSQL Password. For more information, please follow other related articles on the PHP Chinese website!