SELinux is based on the least level of access required for a service to run. Services can be run in a variety of ways; therefore, you must tell SELinux how you are running services. The following Boolean allows you to tell SELinux how you are running PostgreSQL:
allow_user_postgresql_connect
-
Having this Boolean enabled allows any user domain (as defined by PostgreSQL) to make connections to the database server.