How to Find Your PostgreSQL Username and Password on Windows

Where PostgreSQL stores your login information on Windows

PostgreSQL on Windows does not store your password in a single readable file the way some other programs do. Instead, the username is set during installation, and the password is encrypted in the database itself. To find your username, you need to check either the Windows service that runs PostgreSQL or the configuration files PostgreSQL created during setup. The password cannot be retrieved in plain text — you can only reset it if you have forgotten it.

Most Windows installations use a default username of postgres, which is the superuser account created automatically. If you set a different username during installation, you will need to look in the places where PostgreSQL records that choice.

Key Takeaways

The default PostgreSQL username on Windows is postgres, created during installation with a password you set yourself.
You can confirm the username by checking the Windows Services panel or the PostgreSQL data directory configuration files.
PostgreSQL passwords are encrypted and cannot be read from files — if you forget yours, you must reset it using the command line.
The fastest way to verify your username is to open pgAdmin (the graphical tool installed with PostgreSQL) and look at the server connection settings.
If you cannot remember your password, you can reset it by stopping the PostgreSQL service and running a command-line utility.

Check the username through pgAdmin

pgAdmin is the graphical interface that comes with PostgreSQL on Windows. Open it by searching for "pgAdmin" in your Windows Start menu. When pgAdmin opens, look at the left sidebar under "Servers" — you will see a server listed (usually called "PostgreSQL 15" or similar, depending on your version). Right-click on that server name and select "Properties."

In the Properties window, click the "Connection" tab. The "Username" field shows the account name you use to connect to PostgreSQL. This is almost always postgres unless you created a different superuser during installation. Write down this username — you will need it if you ever need to reset your password or troubleshoot connection problems.

Find the username in Windows Services

PostgreSQL runs as a Windows Service, and the service properties can tell you which user account PostgreSQL is running under. Press Windows key + R, type services.msc, and press Enter. This opens the Services panel.

Scroll down until you find a service named something like "postgresql-x64-15" (the number changes depending on your PostgreSQL version). Right-click on it and select "Properties." In the "Log On" tab, you will see which Windows user account runs the service. This is different from your PostgreSQL username, but it confirms PostgreSQL is installed and running. Your PostgreSQL username is still postgres unless you changed it during setup.

Look in the PostgreSQL data directory

PostgreSQL stores configuration information in a data directory. On Windows, this is usually at C:\Program Files\PostgreSQL\15\data (replace 15 with your version number). Open File Explorer and navigate to that folder. You may need to enable viewing hidden files: click the "View" tab at the top and check "Hidden items."

Look for a file called postgresql.conf. Open it with Notepad. This file contains settings but not your username or password in plain text. However, if you search for the word "user" in this file, you may find comments that reference the default user. The actual username used to connect to PostgreSQL is still postgres by default.

Reset your password if you cannot remember it

If you have forgotten your PostgreSQL password, you cannot retrieve it, but you can reset it. First, stop the PostgreSQL service. Press Windows key + R, type services.msc, and press Enter. Find the PostgreSQL service, right-click it, and select "Stop."

Next, open Command Prompt as Administrator. Press Windows key + R, type cmd, right-click the result, and select "Run as administrator." Navigate to the PostgreSQL bin directory by typing this command and pressing Enter:

cd "C:\Program Files\PostgreSQL\15\bin" (replace 15 with your version)

Then type this command to reset the postgres password:

psql -U postgres -d postgres

If this does not work, you may need to start the service in single-user mode. Restart the PostgreSQL service through Services, then try the command again. Once you are connected, type this command to set a new password:

ALTER USER postgres WITH PASSWORD 'newpassword';

Replace 'newpassword' with the password you want to use. Press Enter, then type \q to exit.

Verify your connection with a test

After you have confirmed your username and password, test the connection to make sure everything works. Open pgAdmin again, right-click your server, and select "Connect." If pgAdmin connects without an error, your username and password are correct.

If you get an error message, double-check that you typed the password correctly. PostgreSQL passwords are case-sensitive, so "Password" is different from "password." If you still cannot connect, try resetting the password again using the command-line method above.

Frequently Asked Questions

What is the default PostgreSQL username on Windows?

The default username is postgres. This superuser account is created automatically during installation. If you set a different username during setup, that will be your primary account instead.

Can I see my PostgreSQL password in a file on Windows?

No. PostgreSQL encrypts passwords in the database and does not store them in readable text files. If you forget your password, you must reset it using the command-line tool psql or by stopping the service and using recovery mode.

Where is the PostgreSQL data directory on Windows?

It is usually at C:\Program Files\PostgreSQL\15\data, where 15 is your PostgreSQL version number. You can also find it by checking the PostgreSQL service properties or by looking in pgAdmin under the server settings.

How do I reset my PostgreSQL password if I forgot it?

Stop the PostgreSQL service through Windows Services, open Command Prompt as Administrator, navigate to the PostgreSQL bin folder, and run psql -U postgres -d postgres. Then type ALTER USER postgres WITH PASSWORD 'newpassword'; to set a new password.

Is the PostgreSQL username the same as my Windows username?

No. Your PostgreSQL username (usually postgres) is separate from your Windows login. The PostgreSQL service runs under a Windows user account, but that is also different from your PostgreSQL database username.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.