Install PostgreSQL Pada cPanel/WHM Server

PostgreSQL merupakan salah satu basis data yang paling banyak digunakan saat ini, selain MySQL dan Oracle. PostgreSQL menyediakan fitur yang berguna untuk replikasi basis data. Fitur-fitur yang disediakan PostgreSQL antara lain DB Mirror, PGPool, Slony, PGCluster, dan lain-lain.

PostgreSQL adalah sistem database yang kuat untuk urusan relasi, open source. Memiliki lebih dari 15 tahun pengembangan aktif dan sudah terbukti segala rancangan arsitekturnya telah mendapat reputasi tentang "kuat", "handal", "integritas data", dan "akurasi data".
Sumber: http://id.wikipedia.org/wiki/PostgreSQL

Install PostgreSQL pada cPanel/WHM server sangatlah mudah, ketikkan command berikut:

/scripts/installpostgres

[bash]
root@server5 [~]# /scripts/installpostgres
This script will install PostgreSQL 7.4.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.4.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.4.x style setup. Do not do this if
you have databases that you wish to keep!

Are you sure you wish to proceed? y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.idrepo.or.id
* extras: centos.idrepo.or.id
* updates: centos.idrepo.or.id
Setting up Install Process
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
Resolving Dependencies
--> Running transaction check
---> Package postgresql.x86_64 0:8.4.11-1.el6_2 will be installed
---> Package postgresql-devel.x86_64 0:8.4.11-1.el6_2 will be installed
---> Package postgresql-libs.x86_64 0:8.4.11-1.el6_2 will be installed
---> Package postgresql-server.x86_64 0:8.4.11-1.el6_2 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
postgresql x86_64 8.4.11-1.el6_2 updates 2.7 M
postgresql-devel x86_64 8.4.11-1.el6_2 updates 808 k
postgresql-libs x86_64 8.4.11-1.el6_2 updates 198 k
postgresql-server x86_64 8.4.11-1.el6_2 updates 3.3 M

Transaction Summary
================================================================================
Install 4 Package(s)

Total download size: 7.0 M
Installed size: 32 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 154 kB/s | 7.0 MB 00:46
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : postgresql-libs-8.4.11-1.el6_2.x86_64 1/4
Installing : postgresql-8.4.11-1.el6_2.x86_64 2/4
Installing : postgresql-devel-8.4.11-1.el6_2.x86_64 3/4
Installing : postgresql-server-8.4.11-1.el6_2.x86_64 4/4

Installed:
postgresql.x86_64 0:8.4.11-1.el6_2
postgresql-devel.x86_64 0:8.4.11-1.el6_2
postgresql-libs.x86_64 0:8.4.11-1.el6_2
postgresql-server.x86_64 0:8.4.11-1.el6_2

Complete!

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Installing Bundle::DBD::Pg
.........
.........
.........
.........
.........

The PostgreSQL packages have been installed successfully. To configure,
navigate to WHM's Postgres Config feature where you can set your password
and enable PostgreSQL functionality for existing user accounts.

root@server5 [~]#
[/bash]

Untuk mengaktifkan PostgreSQL, Login WHM → SQL Services → Postgres Config → Klik tombol Install Config - Popup dialog konfirmasi, klik tombol OK

[caption id="attachment_1259" align="alignnone" width="150" caption="PostgreSQL cPanel"][/caption]

Selesai. PostgreSQL database siap digunakan.

[caption id="attachment_1260" align="alignleft" width="150" caption="PostgreSQL cPanel 2"][/caption][caption id="attachment_1261" align="alignleft" width="150" caption="PostgreSQL cPanel 3"][/caption][caption id="attachment_1262" align="alignleft" width="150" caption="PostgreSQL cPanel 4"][/caption]

Untuk uninstall PostgreSQL, jalankan command berikut:

rpm -qa | grep postgre

[bash collapse="false"]
[root@server5 ~]# rpm -qa | grep postgre

// this will show the rpm's for postgre.. now remove it as below ..
// where file is the rpm names that you got from the above command (1).
// there will be a problem uninstalling the lib rpm... just don't worry.. he is of no harm.

#rpm -e
[/bash]

Dokumentasi install PostgreSQL cPanel: http://docs.cpanel.net/twiki/bin/view/AllDocumentation/InstallationGuide/InstallingPostgresql