Use below steps to install or upgrade PostgreSQL on your cPanel server :
1) Run the /usr/local/cpanel/scripts/installpostgres command to install or upgrade PostgreSQL
2) Access WHM >> Home >> SQL Services >> Configure PostgreSQL
3) Click on Install Config if PostgreSQL does not exist on your server
4) Click Create Users to add current cPanel users to PostgreSQL
5) Enter Password and click Change Password button
6) Import your databases
psql dbname < BackupDump.sql