PostgreSQL is an free-opensource object-relational database management system. The objective of this tutorial is to perform an installation and basic configuration of PostgreSQL server on RHEL 8 / CentOS 8 Linux server.
In this tutorial you will learn:
- How to install PostgreSQL database server on RHEL 8 / CentOS 8
- How to start and enable PostgreSQL database server
- How to access PostgreSQL database from localhost and remote location
- How to set password for the default
postgres
user - How to enable PostgreSQL to listen on all networks
- How to secure PostgreSQL remote connection with MD5 password authentication
- How to open PostgreSQL firewall port
- How to establish remote connection to PostgreSQL server using
psql
client