Install, Configure PostgreSQL in Centos Linux 7/8 and Troubleshoot database connection problems

This video describes below.
How to install and configure PostgreSQL on Centos Linux ?
How to create and connect to the database?
How to enable remote connections?
How to connect to remote database?
How to troubleshoot database connection problems?

source

centos 7