install postgresql pada whm server

Install PostgreSQL Pada WHM Server

http://www.linggih.com | Install PostgreSQL Pada WHM Server 1


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

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:

http://linggih.com

http://id.wikipedia.org/wiki/PostgreSQL



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 [~]#

Untuk mengaktifkan PostgreSQL, Login WHM → SQL Services → Postgres Config → Klik tombol Install Config – Popup

dialog konfirmasi, klik tombol OK

http://linggih.com



Selesai. PostgreSQL database siap digunakan.

http://linggih.com



Untuk uninstall PostgreSQL, jalankan command berikut:

rpm -qa | grep postgre

[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.

http://linggih.com



#rpm -e

Article Source:

http://l inggih.com/webserver/databases/postgresql/instal l -postgresql -pada-cpanelwhm -serv er/

http://linggih.com

http://linggih.com/webserver/databases/postgresql/install-postgresql-pada-cpanelwhm-server/

install postgresql pada whm server

Documents