If anyone delete the pg_hba.conf file, and don't run "pg_ctl reload", the configuration of the deleted file is still working.
With that in mind, could someone put in a new file that info wherever it is?
PostgreSQL – How to Recover a Deleted pg_hba.conf File on Linux
linuxpostgresql
Related Question
- PostgreSQL – FATAL: No pg_hba.conf Entry for Host
- PostgreSQL – Fixing Ignored or Not Loaded pg_hba.conf Changes
- PostgreSQL – When Temporary Tables Are Deleted
- PostgreSQL – Error: FATAL: No pg_hba.conf Entry for Host
- PostgreSQL Logging – Impact of Logrotate on Log Files
- Postgresql – What exactly is the use of the column USER in a pg_hba.conf file
- Postgresql – Running the .sql script in Linux to get the postgresql database table and functions
- PostgreSQL PAM Authentication Error – Troubleshooting PostgreSQL Linux PAM Authentication Issues
Best Answer
If you are using Postgres 10, then this is possible through the view pg_hba_file_rules
For earlier versions, I am not aware of any way to retrieve that.