Zion Ahead

Well-Known Member
Nov 10, 2006
347
0
166
Can someone explain how to manually upgrade phppgadmin on a centos 4.5 / cpanel box? I have the following already. I want version 4.12 (or whatever is latest)

phpPgAdmin 4.0.1

[email protected] [~]# rpm -qa|grep postgres
postgresql-server-8.2.1-1PGDG
postgresql-contrib-8.2.1-1PGDG
postgresql-libs-8.2.1-1PGDG
postgresql-devel-8.2.1-1PGDG
postgresql-8.2.1-1PGDG
postgresql-pl-8.2.1-1PGDG


Also, how would I attempt to extract the content in a postgresql database, table "mt059_participants" in the database "tobe_db" in a csv format ?
 

katmai

Well-Known Member
Mar 13, 2006
564
4
168
Brno, Czech Republic
Just made this up, and i am testing it.

cd /usr/local/cpanel/base/3rdparty
mv phpPgAdmin/ phpPgAdmin-bak
wget http://dfn.dl.sourceforge.net/sourceforge/phppgadmin/phpPgAdmin-4.1.2.tar.gz
tar zxf phpPgAdmin-4.1.2.tar.gz
mv phpPgAdmin-4.1.2/ phpPgAdmin
chown -R cpanel:cpanel phpPgAdmin

and it's done.

UPDATE: for some reason i cannot login to the pgsql interface, so i suggest not using the guide yet. i will update it within 1 hour as i have to leave office.
 

reactorh

Well-Known Member
Aug 2, 2005
56
0
156
Just made this up, and i am testing it.

cd /usr/local/cpanel/base/3rdparty
mv phpPgAdmin/ phpPgAdmin-bak
wget http://dfn.dl.sourceforge.net/sourceforge/phppgadmin/phpPgAdmin-4.1.2.tar.gz
tar zxf phpPgAdmin-4.1.2.tar.gz
mv phpPgAdmin-4.1.2/ phpPgAdmin
chown -R cpanel:cpanel phpPgAdmin

and it's done.

UPDATE: for some reason i cannot login to the pgsql interface, so i suggest not using the guide yet. i will update it within 1 hour as i have to leave office.

ANY FIX ON THIS?

THX
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
80
458
cPanel Access Level
Root Administrator
As long as your cPanel install is fully updated, then you will have the latest version of PHPPgAdmin, which is 4.1.3