Install PostgreSQL Server Fedora and CentOS: sudo dnf install postgresql-server Ubuntu 18.04: sudo apt install postgresql New Server Initialization On CentOS 7/Fedora 30: sudo postgresql-setup initdb Upgrading From An Older Version sudo postgresql-setup --upgrade Administering The Database Server Managing The postgresql Daemon Starting PostgreSQL server sudo systemctl start postgresql Checking PostgreSQL Server Status: sudo systemctl status postgresql Enabling PostgreSQL Server Systemd Unit/Enabling PostgreSQL Server On Boot: sudo systemctl enable postgresql Allowing Password Based Login From localhost Edit /var/lib/pgsql/data/pg_hba.