This is offered in cPanel but not turned on by default. Run '/scripts/installpostgres' to install PostgreSQL and it will appear in cPanel if you enable the PostgreSQL feature in the feature manager.

You will get an interface to manage databases and user along with phppgadmin inside of cPanel to manage postgresql for each account. There should be no root interaction unless you need to make custom changes.