You can configure the system for client authentication. You can configure the system for local trust authentication. This allows any local user, including the database super user to connect as a PostgreSQL user without a password. If you want to provide a strong defense and if you do not have significant trust in all local user accounts, use another authentication method. The md5 method is set by default. Verify that md5 is set for all local and host connections.

You can find the client authentication configuration settings for the postgres service instance in /storage/db/vcops/vpostgres/data/pg_hba.conf. Verify that md5 is set for all local and host connections.

The client authentication configuration settings for the postgres-repl service instance can be found in /storage/db/vcops/vpostgres/repl/pg_hba.conf. Verify that md5 is set for all local and host connections.

Note

Do not modify client configuration settings for the postgres user account.