lnmp0.5 如何让php支持 postgresql数据库?

vanvvdot · 发表于 2010-12-17 14:58:19

pgsql是通过yum安装的版本号为8.4.4

我把PHP编译部分改为
./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --with-pgsql=/var/lib/pgsql --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-iconv-dir --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-rpath --enable-discard-path --enable-magic-quotes --enable-safe-mode --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --with-curl --with-curlwrappers --enable-mbregex --enable-fastcgi --enable-fpm --enable-force-cgi-redirect --enable-mbstring --with-mcrypt --enable-ftp --with-gd --enable-gd-native-ttf --with-openssl --with-mhash --enable-pcntl --enable-sockets --with-xmlrpc --enable-zip --enable-soap --without-pear --with-gettext --with-mime-magic --enable-suhosin

重新编译...但是用探针查看,还是没有支持

求教....

licess · 发表于 2010-12-17 15:03:18

已经yum安装了postgresql，在编译参数上加上--with-pgsql ，重新按脚本安装php，重启一下就可以了。

vanvvdot · 发表于 2010-12-17 16:41:02

是将下面的
./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --with-pgsql=/var/lib/pgsql --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-iconv-dir --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-rpath --enable-discard-path --enable-magic-quotes --enable-safe-mode --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --with-curl --with-curlwrappers --enable-mbregex --enable-fastcgi --enable-fpm --enable-force-cgi-redirect --enable-mbstring --with-mcrypt --enable-ftp --with-gd --enable-gd-native-ttf --with-openssl --with-mhash --enable-pcntl --enable-sockets --with-xmlrpc --enable-zip --enable-soap --without-pear --with-gettext --with-mime-magic --enable-suhosin

--with-pgsql=/var/lib/pgsql 改为 --with-pgsql 就可以么?

licess · 发表于 2010-12-17 17:06:37

嗯，再重新按脚本安装php，重启一下就可以了。

vanvvdot · 发表于 2010-12-17 17:08:43

已编译模块检测
date  libxml  openssl  pcre  zlib  bcmath  ctype  curl  dom  filter  ftp  gd
gettext  hash  iconv  json  mbstring  mcrypt  mhash  mime_magic  mysql  SimpleXML  pcntl  SPL
PDO  pdo_sqlite  posix  Reflection  session  shmop  mysqli  soap  sockets  SQLite  standard  sysvsem
tokenizer  xml  xmlreader  xmlrpc  xmlwriter  zip  cgi-fcgi  memcache  pdo_mysql  Zend Optimizer

仍然没有....

./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --with-pgsql --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-iconv-dir --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-rpath --enable-discard-path --enable-magic-quotes --enable-safe-mode --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --with-curl --with-curlwrappers --enable-mbregex --enable-fastcgi --enable-fpm --enable-force-cgi-redirect --enable-mbstring --with-mcrypt --enable-ftp --with-gd --enable-gd-native-ttf --with-openssl --with-mhash --enable-pcntl --enable-sockets --with-xmlrpc --enable-zip --enable-soap --without-pear --with-gettext --with-mime-magic --enable-suhosin

licess · 发表于 2010-12-17 20:09:59

编译参数上加上--with-pgsql ，按脚本重新安装php，重启一下就可以了。
你肯定没重新安装，只configure了一下

vanvvdot · 发表于 2010-12-20 10:00:46

问题找到了,但是不知道怎么解决
configure 时报错
checking for pg_config... not found
configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path

vanvvdot · 发表于 2010-12-20 10:10:38

找到解决办法
yum install postgresql-devel postgresql-libs postgresql-contrib

但是 make 时报错

licess · 发表于 2010-12-20 10:11:24

--with-pgsql=加上pgsql的路径

vanvvdot · 发表于 2010-12-20 10:13:15

make ZEND_EXTRA_LIBS='-liconv' 时报错

make: *** [sapi/cgi/fastcgi.lo] Error 1

vanvvdot · 发表于 2010-12-20 10:15:08

加上了

./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-iconv-dir --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-rpath --enable-discard-path --enable-magic-quotes --enable-safe-mode --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --with-curl --with-curlwrappers --enable-mbregex --enable-fastcgi --enable-fpm --enable-force-cgi-redirect --enable-mbstring --with-mcrypt --enable-ftp --with-gd --enable-gd-native-ttf --with-openssl --with-mhash --enable-pcntl --enable-sockets --with-xmlrpc --enable-zip --enable-soap --without-pear --with-gettext --with-mime-magic --enable-suhosin --with-pgsql=/var/lib/pgsql

		自动登录	找回密码
密码			注册

lnmp0.5 如何让php支持 postgresql数据库?

回复 1# 的帖子

军哥运维代购：http://shop63846532.taobao.com/

回复 5# 的帖子

回复 7# 的帖子