configuration postgresql & phpPgAdmin

29 Jan

1. download
http://transact.dl.sourceforge.net/sourceforge/phppgadmin/phpPgAdmin-4.2.2.tar.gz
2. extract
[root@bb ~]# tar xvf /home/admin/-4.2.2.tar.gz -C /var/www/html/
[root@bb ~]# cd /var/www/html/
[root@bb html]# mv phpPgAdmin-4.2.2 phpPgAdmin

3. edit config
[root@bb html]# cd phpPgAdmin/
[root@bb phpPgAdmin]# vim conf/config.inc.php
$conf[‘servers’][0][‘host’] = ‘172.20.88.88’;

4. testing
[root@bb phpPgAdmin]# firefox http://172.20.88.88/phpPgAdmin
Your PHP installation does not support PostgreSQL. You need to recompile PHP using the –with-pgsql configure option.

5. check package
[root@bb php.d]# rpm -qa | grep php
php-common-5.1.6-5.el5
php-cli-5.1.6-5.el5
php-5.1.6-5.el5
php-ldap-5.1.6-5.el5

[root@bb php.d]# rpm -ivh php-pgsql-5.1.6-5.el5.i386.rpm php-pdo-5.1.6-5.el5.i386.rpm
[root@bb php.d]# service httpd restart

6. testing
[root@bb phpPgAdmin]# firefox http://172.20.88.88/phpPgAdmin

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: