PostgreSQL – How to Edit pg_hba.conf File Using pgAdmin 4

pg-hba.confpgadminpgadmin-4postgresql

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 edit postgresql.conf via pgAdmin is that the ALTER SYSTEM syntax is something that can be entered into a client interface. Therefore, pgAdmin was able to "edit" postgresql.conf because it could send an ALTER SYSTEM query to the database. No such syntax exists for editing access control.