pg Admin 4 - password for "postgres" user when trying to connect to PostgreSQL 13 server

Question

I know that this question has been asked other times but I didn't find a solution to this problem!

I downloaded PostgreSQL 13 with pg Admin 4 and when I open it for the first time after installation it asks me for the master password that I was asked to set during installation, after I give the master password and this gets accepted I try to connect to the default server created during the installation: "PostgreSQL 13".

At this point, it asks me for a password for the user "postgres" that I don't know where to find. Specifically, it says: Please enter the password for the user 'postgres' to connect the server - "PostgreSQL 13".

I've already tried all the "default" passwords I managed to find on the internet but the error is always the same:

FATAL: password authentication failed for user "postgres"

I've also tried not to insert any password with the resulting error:

fe_sendauth: no password supplied

I don't know what to do. In PostgreSQL 13 the authentication method is encrypted via scram-sha-256. I already tried to set the method to trust, restart the mac, and open pg Admin 4 that keeps asking me for the password to access the server.

I've also tried to use the command line tool but end up encountering the same errors.

Finally, this is how my pg_hba.conf looks like:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     scram-sha-256
# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
# IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     scram-sha-256
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

PS. I've also tried to uninstall PostgreSQL 13, deleting the postgres user and re-download and re-install everything... nothing changed.

If someone could help me would become my savior, thanks beforehand!

I'm assuming this is the Windows install. Use the master password, it is also the password for `postgres` user. — Adrian Klaver, Oct 04 '20 at 20:45
Hi I'm running into the exact same issue, did you find a solution for this? — roe, Nov 10 '20 at 00:19
People looking for Pgadmin4 password on StackOverflow should be a hint that it's retarded feature and totally useless. — html_programmer, Aug 17 '22 at 18:04

score 43 · Accepted Answer · answered Oct 10 '20 at 04:43

43

I ran into the same problem recently. The solution below works for me. I'm using Windows btw, so you should try equivalent commands in your OS.

Change METHOD of all rows in your pg_hba.conf file from scram-sha-256 to trust
Add bin folder of Postgres installation to path, if you haven't
Open command prompt and enter psql -U postgres. You won't be asked for password here.
Enter \password postgres
Choose and confirm your password
Revert pg_hba.conf to original state

Now you should be able to enter password for postgres in pgAdmin.

answered Oct 10 '20 at 04:43

dlam

446
4
3

Which version is this for? `psql -U postgres` still asking the password in step 3. – roe Nov 09 '20 at 08:42
1

I use PostgreSQL 13. Did you forget to save conf file in step 1? Also try editing with Notepad++ and running command prompt as administrator to see if it can make a difference. If nothing helps, try downloading a new installer as it now provides password prompt during installation. – dlam Nov 10 '20 at 23:40
This worked perfectly for me running PostgreSQL 14 – NoName123 Jun 25 '22 at 09:02

score 18 · Answer 2 · answered Jan 26 '21 at 18:52

18

Just for reference: I ran into the same issue on ubuntu-20.04 running postgresql-13.1. To solve it with this configuration I had to run the following commands in the terminal:

sudo su postgres
psql
\password postgres
enter your password twice

Afterwards, I could log in through pgAdmin4 as usual, providing the set password.

answered Jan 26 '21 at 18:52

eo_coder_jk

181
1
5

`sudo` was the key for me. It asked for a password without that even though none was set. – Akaisteph7 Aug 08 '23 at 19:50

score 5 · Answer 3 · answered Mar 16 '21 at 13:05

5

The method that worked for me (Windows 10 x64, PostgreSQL 13):

Edit C:\Program Files\PostgreSQL\13\data\pg_hba.conf and set "METHOD" column values to trust (security breach, only for testing purposes)
Open Powershell as admin, go to C:\Program Files\PostgreSQL\13\bin
Type pg_ctl reload, press Enter.
Launch pgAdmin again

answered Mar 16 '21 at 13:05

Alberto Luengo Cabanillas

51
2
3

This worked for me (Windows 10 x64, PostgreSQL 14) thanks!! – VINIT CHURI Aug 27 '22 at 05:54

score 3 · Answer 4 · answered Mar 31 '21 at 16:11

3

If you doing this first time, delete all the existing folders of PostgreSQL in program files and program files 64.

Then run the installation again, it worked. Asking for new password.

In case you remember the master password. The default user name is postgres

answered Mar 31 '21 at 16:11

Arun Prasad E S

9,489
8
74
87

1

This is the right answer. For some reason the password if pasted in or if too complex (not sure which) will not work later... – its.me.adam May 26 '23 at 19:14

score 3 · Answer 5 · answered May 22 '22 at 19:06

To disable the master password do the following:

Locate the "Config.py" file. It's usually located in "C:\Program Files\PostgreSQL\12\pgadmin 4\web" or "C:\Program Files (X86)\pgAdmin4\v4\web" In this directory create a new file named "Config_local.py" and add the line MASTER_PASSWORD_REQUIRED=False. If the "Config_local.py" already exist, edit it, and add the line at the bottom of the file. Save the file. Close PGAdmin4 and reopen it. You should now be able to access PGAdmin without the master password.

https://community.progress.com/s/article/pgadmin-4-ask-for-master-password

score 2 · Answer 6 · answered Jun 02 '21 at 01:29

2

Just type the password you enter to start your PC(user/admin password).

answered Jun 02 '21 at 01:29

Saad AK

45
3

score 1 · Answer 7 · answered Oct 10 '20 at 03:48

In my case I installed PostgreSQL 10 and 13 on CentOS 8 by error, so I uninstall both PostgreSQL and installed PostgreSQL 13 following the instructions from PostgreSQL web site, no other website.

How to unistall PostgreSQL

How to install correctly PostgreSQL

And after I change the password postgres user/role by Terminal (pgAdmin 4 web postgres user/role is diferent and diferente service):

# sudo -i -u postgres
[postgres@server ~$] psql
postgres=# ALTER USER postgres PASSWORD 'postgres';
ALTER ROLE
postgres=# /q
[postgres@server ~$] exit
# sudo systemctl restart postgresql-13

score 1 · Answer 8 · answered Oct 24 '21 at 01:36

Found a easy steps.

Change METHOD of # IPv4 local connections row in your pg_hba.conf file from scram-sha-256 to trust.
Change the Host name/address in Connection tab to "127.0.0.1" of the Server-PostgreSQL 13(14).
Connect to Server-PostgreSQL 13(14) and input empty string.

Now you should be able to log in with username postgres and create Login/Group role for your specific database.

Arman Fagradyan · Answer 9 · 2022-10-24T15:49:30.717

The following worked for me. Change METHOD of all rows in your pg_hba.conf file from scram-sha-256 to trust (C:\Program Files\PostgreSQL\14\data\pg_hba.conf). This will disable password for your DB. Click on any database in postgresql to use Query Tool.

In Query Tool type ALTER USER postgres WITH PASSWORD 'User_password'; postgres is default username, execute it. This way you can set up a password for your DB, after that go back to the first step and change it back from trust to scram-sha-256.

score 1 · Answer 10 · edited Jan 09 '23 at 14:44

1

sudo -i -u postgres

psql
ALTER USER postgres PASSWORD 'new_password';
\q
exit

edited Jan 09 '23 at 14:44

Adriaan

17,741
7
42
75

answered Jan 09 '23 at 14:43

Amina K M

15
3

score 0 · Answer 11 · answered Oct 05 '20 at 14:12

Did Setup prompt you for a password while installing?

If not, uninstall PostgreSQL using Windows Add or Remove Programs, delete everything under C:\Program Files\PostgreSQL and re-install. This time, you should be prompted for a password for user postgres and use the same password in pgAdmin4.

score 0 · Answer 12 · answered Nov 01 '20 at 05:26

Edit the pg_hba.conf located in the data folder. At the bottom, where it starts: local all all scram-sha-256 change all instances of "scram-sha-256" to "trust", like... local all all trust Save the file and you should be able to get right in.

score 0 · Answer 13 · answered Jan 07 '22 at 19:30

I had the same problem after installing pgadmin4, in that I was able to use a master password, but the postgres password was not accepted. After spending hours attempting to sync postgresql and pgadmin to recognize the postgres password, I finally deleted/removed the server identified in pgadmin4 and created a new one using the same hostname as the original. The postgres db was immediately recognized. I created other dbs, assigned users and exited. When I re-opened pgadmin4, both the master password and postgres were accepted and I was able to complete my work. Hope this helps others same some time and aggravation.

score 0 · Answer 14 · answered Apr 12 '22 at 15:52

0

It happened to me as well after a computer re-start. PostgreSQL was not running and I had to spin it up manually. Once done, I just had to hit enter (no password).

answered Apr 12 '22 at 15:52

Andy

1,307
1
12
17

rebel_codeaz · Answer 15 · 2022-07-05T14:58:46.160

0

The answer by @dlam works. But the problem remains same. It doesn't accept password when I use psql I found a workaround by using psql -U postgres instead of psql. Or using SQL Shell(psql) also works That works fine.

Any better solutions are welcomed!

edited Jul 05 '22 at 14:58

answered Jul 05 '22 at 14:46

rebel_codeaz

101
1
7

score 0 · Answer 16 · answered Aug 31 '22 at 16:34

0

1-change the port number 2-click to postgreSQL13 3-go to connection and change port for 5432

answered Aug 31 '22 at 16:34

kbhit22 kbhit22

1

It said FATAL: password authentication failed for user "postgres" If it was wrong port, the error msg would indicate that :) Always make sure you understand the question. Welcome to stackoverflow and please check this: https://stackoverflow.com/help/how-to-answer – Rabhi salim Sep 05 '22 at 15:03
It said FATAL: password authentication failed for user "postgres" If it was wrong port, the error msg would indicate that :) Always make sure you understand the question. Welcome to stackoverflow and please check this: stackoverflow.com/help/how-to-answer – Rabhi salim Sep 05 '22 at 15:03

score 0 · Answer 17 · answered Apr 22 '23 at 17:38

0

i just wrote - "password" and it worked. In PostgreSql 15

answered Apr 22 '23 at 17:38

Jamila Ali

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Apr 26 '23 at 14:36

score -1 · Answer 18 · edited Jan 02 '22 at 01:14

-1

This works for me every time I'm setting up.

sudo -u postgres -i
psql
\password postgres

After that, enter your password twice.

Then use that password in the pgAdmin4.

edited Jan 02 '22 at 01:14

kağan hazal koçdemir

715
4
18

answered Dec 25 '21 at 18:37

Mohamed Ahmed

77
6

You should improve your answer, because there are so many upvoted answers which have the same instruction but with more details. – Muhammad Dyas Yaskur Dec 25 '21 at 20:00

pg Admin 4 - password for "postgres" user when trying to connect to PostgreSQL 13 server

18 Answers18

Linked