Thursday, May 2, 2024
 Popular · Latest · Hot · Upcoming
0
rated 0 times [  0] [ 0]  / answers: 1 / hits: 2182  / 3 Years ago, mon, august 2, 2021, 3:57:44

Recently I have faced with issue that I cannot change password that is used in pgAdmin for connection to remote database ...


In pg_hba.conf (PostgresSQL 12) I have the following login capabilities:


# Database administrative login by Unix domain socket
local all postgres peer

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 0.0.0.0/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
hostnossl all all 0.0.0.0/0 trust

I tried to change password for postgres user, also tried to change password of postgres role in database nothing helped ...


Is there a way to change default password for connection to PostgresSQL ?


More From » password

 Answers
4

The issue was that I used the following line in pg_hba.conf:


...
hostnossl all all 0.0.0.0/0 trust

That is way it was not necessary to use password for connection with database


I changed it to:


hostnossl       all     all             0.0.0.0/0               md5

[#1064] Monday, August 2, 2021, 3 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
bewre

Total Points: 164
Total Questions: 108
Total Answers: 106

Location: Ghana
Member since Sun, Mar 27, 2022
2 Years ago
bewre questions
Sun, May 14, 23, 13:27, 1 Year ago
Thu, Aug 26, 21, 18:05, 3 Years ago
Sat, Aug 6, 22, 21:41, 2 Years ago
Sat, Jul 24, 21, 22:52, 3 Years ago
Sun, Mar 12, 23, 04:23, 1 Year ago
;