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?