Sample Header Ad - 728x90

PSQL asks for password for a specific database

0 votes
1 answer
135 views
I am hosting two different databases (manage_invite and manage_invite_v49) on the same server. enter image description here As you can see, when I try to connect them using the CLI, it demands the password for the second database only. But they are on the same server therefore the pg_hba.conf file is the same for both database. **Do you know what could the issue be?** I would like my manage_invite_v49 db to be accessible without a password, as the first one. Here is my pg_hba.conf file:
# 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                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/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
Asked by Androz2091 (113 rep)
Jun 10, 2021, 08:57 PM
Last activity: Jun 10, 2021, 09:56 PM