Installing Postgresql and having Plesk recognize it as a valid database option is almost as easy as installing it outside Plesk but with one additional step. You have to tell plesk postgresql is installed on the server.
# yum install postgresql postgresql-server
After yum downloads and installs the server you have to start the service: