一、更换yum原
# yum install epel-release
# rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
二、安装php PostgreSQL扩展
# yum install php72w-pgsql
三、vi pg_hba.conf: # IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
四、编写测试脚本 pgconn.php
<?php
$connStr = "host=localhost port=5432 dbname=postgres user=postgres password=password";
//simple check
$conn = pg_connect($connStr);
$result = pg_query($conn, "select * from pg_stat_activity");
print_r(pg_fetch_all($result));
?>
五、测试/usr/bin/php pgconn.php
六、reboot
七、浏览器访问pgconn.php