This other Question has Answers about viewing and editing settings in postgresql.conf
file using pgAdmin 4. But those Answers did not mention editing the pg_hba.conf
file used for authentication of users.
➥ How to use pgAdmin 4 for editing the pg_hba.conf
file?
Best Answer
No, pgAdmin cannot edit
pg_hba.conf
Unfortunately, there is no mechanism by which pgAdmin can edit a
pg_hba.conf
file. The reason why it's possible to editpostgresql.conf
via pgAdmin is that theALTER SYSTEM
syntax is something that can be entered into a client interface. Therefore, pgAdmin was able to "edit"postgresql.conf
because it could send anALTER SYSTEM
query to the database. No such syntax exists for editing access control.