Comments on: PostgreSQL Security: Best Practices for Securing Your PostgreSQL Database https://www.percona.com/blog/postgresql-database-security-what-you-need-to-know/ Tue, 30 Jan 2024 17:37:59 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: LEMJID https://www.percona.com/blog/postgresql-database-security-what-you-need-to-know/#comment-10973661 Wed, 13 Jul 2022 08:18:03 +0000 https://www.percona.com/blog/?p=73259#comment-10973661 Hi,
You should add “passwords” to internal authentication.
Thanks

$psql -c “SELECT pg_read_file(‘pg_hba.conf’);” | head -n -41 | tail -n 3
# METHOD can be “trust”, “reject”, “md5”, “password”, “gss”, “sspi”, “krb5”, +
# “ident”, “pam”, “ldap” or “cert”. Note that “password” sends passwords +
# in clear text; “md5” is preferred since it sends encrypted passwords. +
==> Informations from hba_conf_file.

]]>