关于redhat 7.2的Pgsql 7.3.3 [英] Pgsql 7.3.3 on redhat 7.2
问题描述
>我不能为一个小家伙休息。
> I can''t get a rest for a min guys.
我周末离开，我的服务器收到此错误。
致命错误：调用未定义的函数：第79行的/var/www/html/crohns/phpBB2/db/postgres7.php中的pg_connect（）
I go away for the weekend and my server is getting this error.
Fatal error: Call to undefined function: pg_connect() in
/var/www/html/crohns/phpBB2/db/postgres7.php on line 79
你的PHP没有对PostgreSQL的支持。
看看phpinfo（）;
--->
从备份到当前的php.ini文件......这就是改变了...
看起来像是关于php的自动更新。
这在当前的php.ini中被关闭了
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;文件上传;
;;;;;;;;;;;;;;;
;是否允许HTTP文件上传。
file_uploads =关闭
备份已经调整好
？
这个原因呢？
-Dan
------------- --------------（广播结束）---------------------------
提示1：订阅和取消订阅命令转到 ma*******@postgresql.org
Your PHP doesn''t have support for PostgreSQL.
Look at phpinfo();
--->
From the backup to the current php.ini file... this is what was changed...
Looks like an autoupdate on php happened.
This was turned off in the current php.ini
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;
; Whether to allow HTTP file uploads.
file_uploads = Off
the backup had this tuned on
?
this cause it?
-Dan
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
推荐答案
El Lun 2003年10月20日11:08，Daniel E.Fisherescribió：
El Lun 20 Oct 2003 11:08, Daniel E. Fisher escribió:
来自备份到当前的php.ini文件......这就是改变了......
看起来像是关于php的自动更新。
这在当前的php.ini中被关闭了br />
;;;;;;;;;;;;;;;
;文件上传;
;;;;;;;;;;;;;;;
;是否允许HTTP文件上传。
file_uploads =关闭
这无关。
备份已调整
From the backup to the current php.ini file... this is what was changed...
Looks like an autoupdate on php happened.
This was turned off in the current php.ini
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;
; Whether to allow HTTP file uploads.
file_uploads = Off
This has nothing to do.
the backup had this tuned on
echo"<？php phpinfo（）？>" | php | lynx
很明显你没有使用你的RH 7.2附带的PostgreSQL，并且
（有人纠正我）我认为libpq客户端改变了，所以重新编译需要
。
顺便提一下，你应该提供更好的服务器信息。告诉我们
您正在使用的PHP版本。它有RH吗？ PgSQL怎么样？
-
11:25:01上升17天，20：57,3位用户，平均负载：0.29,0.73,0.96
------------------------------------------ -----------------------
$ b $bMartínMarqués| mm******@unl.edu.ar
Programador，Administrador ，DBA | Centro de Telematica
Universidad Nacional
del Litoral
------------------- ----------------------------------------------
---------------------------（播出结束）-------------- -------------
提示2：您可以使用取消注册命令立即取消所有列表
（发送取消注册YourEmailAddressHere ; ma*******@postgresql.org ）
echo "<?php phpinfo() ?>" | php | lynx
Aparently you are not uning the PostgreSQL that came with your RH 7.2, and
(somebody correct me) I think the libpq client changed, so recompilation is
needed.
By the way, you should give better information about the server. Tell us about
what version of PHP you are using. Did it come with RH? How about PgSQL?
--
11:25:01 up 17 days, 20:57, 3 users, load average: 0.29, 0.73, 0.96
-----------------------------------------------------------------
Martín Marqués | mm******@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
2003年10月20日星期一上午10:08:08 -0400，Daniel E. Fisher写道：
On Mon, Oct 20, 2003 at 10:08:08AM -0400, Daniel E. Fisher wrote:
从备份到当前的php.ini文件......这是改变了...
From the backup to the current php.ini file... this is what was changed...
看起来像是关于php的自动更新。
这是关闭的在当前的php.ini
Looks like an autoupdate on php happened.
This was turned off in the current php.ini
嗯，这听起来不会影响Postgres的支持。
然而可能有什么碰巧（我已经看过了）就是这样e之前的某些更改没有生效，因为服务器没有重新启动
。所以，如果这是你第一次重启httpd，那么你可以更好地开始调查...
如果你背后有更新，也许libpq
共享库更改版本（libpq.so.2 - > libpq.so.3），现在PHP
无法加载它。阅读你的服务器日志...
-
Alvaro Herrera（< alvherre [a] dcc.uchile.cl>）
你敲门或太阳照射在你体内的地方
，太阳通常不会闪耀 （死亡：高生活成本）
------------------------- - （广播结束）---------------------------
提示9：规划人员会忽略你的如果您的
加入列的数据类型不匹配，则需要选择索引扫描
Huh, it doesn''t sound like it could affect the Postgres support.
However what could have happenned (I''ve seen it) is that there was some
previous change that didn''t take effect because the server wasn''t
restarted. So if this is your first httpd restart in some time, you
better start investigating...
If you are having updates applied behind your back, maybe the libpq
shared library changed version (libpq.so.2 -> libpq.so.3), and now PHP
is failing to load it. Read your server logs ...
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"You knock on that door or the sun will be shining on places inside you
that the sun doesn''t usually shine" (en Death: "The High Cost of Living")
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match
我在/ var中/ lib /
libpq.so.2
libpq.so.2.0
libpq.so.2.1
libpq.so
也找到了
/usr/local/pgsql/lib/libpq.so.3
/ usr / local / pgsql / lib / libpq.so.3.0
/usr/local/pgsql/lib/libpq.so
阅读完所有服务器日志后：
没有错误信息或什么也没有。奇怪..
可能与阅读错误的libpq Alvaro有关吗？
-Dan
-Always感谢帮助
-----原帖-----
来自：Alvaro Herrera [mailto：al ****** @发送时间：2003年10月20日星期一上午11点28分
致：Daniel E. Fisher
Cc： PGSQL列表
主题：Re：[GENERAL]关于redhat 7.2的Pgsql 7.3.3
2003年10月20日星期一上午10:08:08 -0400，Daniel E .Fisher写道：
I have in the /var/lib/
libpq.so.2
libpq.so.2.0
libpq.so.2.1
libpq.so
also found
/usr/local/pgsql/lib/libpq.so.3
/usr/local/pgsql/lib/libpq.so.3.0
/usr/local/pgsql/lib/libpq.so
After reading all my server logs:
No error messages or nothing. Weird..
May have something to do with reading wrong libpq Alvaro?
-Dan
-Always appreciative of help
-----Original Message-----
From: Alvaro Herrera [mailto:al******@dcc.uchile.cl]
Sent: Monday, October 20, 2003 11:28 AM
To: Daniel E. Fisher
Cc: PGSQL List
Subject: Re: [GENERAL] Pgsql 7.3.3 on redhat 7.2
On Mon, Oct 20, 2003 at 10:08:08AM -0400, Daniel E. Fisher wrote:
从备份到当前的php.ini文件......这就是
From the backup to the current php.ini file... this is what was
已更改......看起来像是关于php的自动更新。
这在当前的php.ini中被关闭了
changed... Looks like an autoupdate on php happened.
This was turned off in the current php.ini
嗯，它没有'听起来它可能会影响Postgres的支持。
然而可能发生的事情（我已经看过了）是有一些
之前的变化没有'不要效果，因为服务器没有重新启动
。所以，如果这是你第一次重启httpd，那么你可以更好地开始调查...
如果你背后有更新，也许libpq
共享库更改版本（libpq.so.2 - > libpq.so.3），现在PHP
无法加载它。阅读你的服务器日志...
-
Alvaro Herrera（< alvherre [a] dcc.uchile.cl>）
你敲门或太阳照射在你体内的地方
，太阳通常不会闪耀 （死亡：高生活成本）
---------------------------（结束广播）---------------------------
提示4：不要杀人-9 ''邮政局长
Huh, it doesn''t sound like it could affect the Postgres support.
However what could have happenned (I''ve seen it) is that there was some
previous change that didn''t take effect because the server wasn''t
restarted. So if this is your first httpd restart in some time, you
better start investigating...
If you are having updates applied behind your back, maybe the libpq
shared library changed version (libpq.so.2 -> libpq.so.3), and now PHP
is failing to load it. Read your server logs ...
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"You knock on that door or the sun will be shining on places inside you
that the sun doesn''t usually shine" (en Death: "The High Cost of Living")
---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
这篇关于关于redhat 7.2的Pgsql 7.3.3的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
