Answered by the Webhosting Experts
Tags +
...

cPanel Servers
at Hivelocity

Introducing: Flat Rate Pricing
The most affordable way to run a cPanel Dedicated Server. Simple, flat rate pricing in 3 tiers.

1-500 Accounts $45/mo.

501-1000 $114/mo.

1001+ Accounts $189/mo.
(*Plus $.175/additional account)

Tags +
...
Tags
...
...
160x600_hivelocity_dec20

Installing Postgresql

Installing Postgresql – HOWTO
cPanel requires Postgresql 7.3.x or later. 7.2.x will not work.

===========================================
Step 1
===========================================
Upgrade to cPanel 7.4.0 build 45 or later
===========================================

===========================================
Step 1a (If you do not have 7.2.x or earlier installed skip this step)
===========================================
Login to a root shell via ssh or the console.

If you have Postgres 7.2.x installed, backup your databases using pg_dumpall or some other method.

Move the postgres data directory somewhere else. ie

mv /var/lib/pgsql /var/lib/pgsql.old
===========================================

===========================================
Step 2
===========================================
Login to a root shell via ssh or the console and run

/scripts/installpostgres
===========================================

===========================================
Step 2a (skip this step if you are not upgrading from postgres 7.2 or earlier
===========================================
Restore your sql dump created with pg_dumpall or by some other method using psql or some other method
===========================================
29110310

===========================================
Step 3
===========================================
Login to Web Host Manager and choose “Postgres Config” under Server Setup.

Set a postgres password to anything of your choosing. You should avoid using any non-alpha numeric charaters as these cause problems.
===========================================

===========================================
Step 4
===========================================
Use the “Postgres Config” option in WHM to install a postgres pg_hba.conf file. You can skip this step if you would like to setup your pg_hba.conf file manually. cPanel should work fine with md5 passwords or plaintext passwords
===========================================

Share

Facebook
Twitter
LinkedIn
Email
WhatsApp

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: support@hivelocity.net. We are also available to you through our phone and live chat system 24/7/365.

Watch our servers in their natural habitat

Click here to see more live streams or take a tour of our facilities.

cPanel Servers
at Hivelocity

Introducing: Flat Rate Pricing
The most affordable way to run a cPanel Dedicated Server. Simple, flat rate pricing in 3 tiers.

1-500 Accounts $45/mo.

501-1000 $114/mo.

1001+ Accounts $189/mo.
(*Plus $.175/additional account)