phpPgAdmin is a web application, written in PHP and web-based administration utility for managing PostgreSQL databases. It handles all the basic functionality as well as some advanced features such as triggers, views and functions. It can create databases, create tables, alter tables and query the data. In this post, i will show how to install phpPgAdmin for PostgreSQL Databases on linux CentOS 6.2 server. Assumed that you have already configured EPEL repository.<\/p>\n
\n[root@centos62 ~]# yum install phpPgAdmin -y\nLoaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: mirror.averse.net\n * epel: ftp.riken.jp\n * extras: mirror.averse.net\n * updates: mirror.issp.co.th\nSetting up Install Process\nResolving Dependencies\n--> Running transaction check\n---> Package phpPgAdmin.noarch 0:5.0.3-1.el6 will be installed\n--> Processing Dependency: php-pgsql >= 4.2 for package: phpPgAdmin-5.0.3-1.el6.noarch\n--> Running transaction check\n---> Package php-pgsql.i686 0:5.3.3-3.el6_2.6 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n====================================================================================================\n Package Arch Version Repository Size\n====================================================================================================\nInstalling:\n phpPgAdmin noarch 5.0.3-1.el6 epel 909 k\nInstalling for dependencies:\n php-pgsql i686 5.3.3-3.el6_2.6 updates 67 k\n\nTransaction Summary\n====================================================================================================\nInstall 2 Package(s)\n\nTotal download size: 976 k\nInstalled size: 4.9 M\nDownloading Packages:\n(1\/2): php-pgsql-5.3.3-3.el6_2.6.i686.rpm | 67 kB 00:00\n(2\/2): phpPgAdmin-5.0.3-1.el6.noarch.rpm | 909 kB 00:10\n----------------------------------------------------------------------------------------------------\nTotal 83 kB\/s | 976 kB 00:11\nRunning rpm_check_debug\nRunning Transaction Test\nTransaction Test Succeeded\nRunning Transaction\n Installing : php-pgsql-5.3.3-3.el6_2.6.i686 1\/2\n Installing : phpPgAdmin-5.0.3-1.el6.noarch 2\/2\nNon-fatal POSTIN scriptlet failure in rpm package phpPgAdmin-5.0.3-1.el6.noarch\nwarning: %post(phpPgAdmin-5.0.3-1.el6.noarch) scriptlet failed, exit status 7\n\nInstalled:\n phpPgAdmin.noarch 0:5.0.3-1.el6\n\nDependency Installed:\n php-pgsql.i686 0:5.3.3-3.el6_2.6\n\nComplete!\n<\/pre>\n","protected":false},"excerpt":{"rendered":"phpPgAdmin is a web application, written in PHP and web-based administration utility for managing PostgreSQL databases. It handles all the basic functionality as well as some advanced features such as…<\/p>\n","protected":false},"author":6,"featured_media":2488,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":0,"footnotes":""},"categories":[1029,2062],"tags":[1244,1253,1322,1536,1546,1659,1665],"class_list":["post-2487","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-yum","tag-centos","tag-centos-6-2","tag-database","tag-linux","tag-linux-utilities","tag-phppgadmin","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/2487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/comments?post=2487"}],"version-history":[{"count":0,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/2487\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media\/2488"}],"wp:attachment":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media?parent=2487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/categories?post=2487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/tags?post=2487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}