Information
Trust authentication assumes that anyone who can connect to the server is authorized to access the database. Trust authentication is only
suitable for TCP/IP connections if you trust every user on every machine that is allowed to connect to the server by the pg_hba.conf lines
that specify trust. It is seldom reasonable to use trust for any TCP/IP connections.
OWASP Backend Security Project PostgreSQL Hardening - https://www.owasp.org/index.php/OWASP_Backend_Security_Project_PostgreSQL_Hardening
NOTE: update POSTGRESQL_VERSION with the appropriate value for the local environment.