How to Install PostgreSQL on linux cPanel Server ?

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensible, and the dedication of the open source community behind the software to consistently deliver performance and innovative solutions. Silicon House provides the fully managed linux dedicated serverhttps://www.siliconhouse.net/dedicated-servers-managed where you can have the backend shell access and unlimited sub reseller account create privilege.

The following are the necessary steps that a cPanel user must follow in order to update or install PostgreSQL:

The user must run the given command – /usr/local/cpanel/scripts/installpostgres – It is this command that will initiate the entire process.

To the Configure PostgreSQL interface of WHM (Web Host Manager). Kindly follow the below steps :

1.This may be done by simply clicking on the SQL Services option on the Home page of WHM.

2.If one is installing the software for the first time on his or her device, one must click on the Install/Config option available. In case one has PostgreSQL pre-installed, this command will override any former ones to perform the same function. Hence, this acts also as a way to update PostgreSQL.

3.Once this is complete the user may add existing cPanel users to the PostgreSQL by simply using the Create Users.

4.Finally, for security purposes it is advisable that the root user choose a complex, new password for his or her account.

Once all of this is done, the user may safely import and hence restore all of his or her databases by issuing the following command –

psql dbname < dumpfile.sql