Resetting the pgadin4 web usto run,er credentials

From: Kevin Struckhoff <kevinstruckhoff(at)yahoo(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Resetting the pgadin4 web usto run,er credentials
Date: 2021-07-27 22:20:27
Message-ID: 541517086.396547.1627424427823@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

After getting pgadmin4 installed and configured, I've found out that the user credentials I specified during the setup don't work very well. I've added the user to the postgres db using the adduser command. I updated the pg_hba.conf file with an entry just for the user but I get this error when trying to connect for the 1st time:
FATAL: no pg_hba.conf entry for host " my.dbserver.ip.addr", user "p(at)p(dot)com", database "postgres", SSL off
psql postgres
postgres-# adduser p(at)p(dot)compostgres-#\q

pg_hba.conf entries (actual ip number hidden):
host    all             all             my.dbserver.ip.addr/32 trust    host    all             p(at)p(dot)com         my.dbserver.ip.addr /32 trust    # for pgadmin4 web
So I would have thought the 1st entry would cover all users. I can't create a linux user because the user name is invalid:
useradd: invalid user name 'p(at)p(dot)com'
So to make it work, I'd just like to set the username/password to the postgres user. Where can I do that? I don't see a .py or .conf file other than pg_hba.conf where the user is defined.

Thanks. Kevin

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Kevin Struckhoff 2021-07-27 22:27:58 Re: Resetting the pgadmin4 web user credentials
Previous Message Kevin Struckhoff 2021-07-27 19:27:25 Re: Installing pgAdmin-web on CentOS 8 not working