Fatal error: Call to undefined function: pg_connect()
Hi All,
I updated postgre from 7.2.4 to 7.3.2 in my RHLinux7.3 system and updated
current pghba.conf and postgresql.conf files as per my need. But If I try to
connect through PHP which was connecting earlier with 7.2.4 is giving the
following error
Fatal error: Call to undefined function: pg_connect()
Can any body encounter the same problem earlier can help me that in solving.
Thanks alot,
Sreedhar Bhaskararaju
Is it necessary to uninstall previous version of PHP in my system. Which is
the better compatible version for Postgre 7.3.2.
Can you give any link/info for recompiling PHP
Sreedhar
----- Original Message -----
From: "Jean-Christian Imbeault" <jc@mega-bucks.co.jp>
To: "shreedhar" <shreedhar@lucidindia.net>
Sent: Tuesday, August 05, 2003 11:33 AM
Subject: Re: [GENERAL] Fatal error: Call to undefined function: pg_connect()
Show quoted text
shreedhar wrote:
Fatal error: Call to undefined function: pg_connect()
This is a PHP error. Guessing you re-compile PHP and forgot to include
postgres support, or somehow the libraries got moved.You'll probably need to recompile PHP is my best guess.
Jean-Christian Imbeault
shreedhar wrote:
Is it necessary to uninstall previous version of PHP in my system.
No，but a new recompile will probably over-write the version you have now.
Which is the better compatible version for Postgre 7.3.2.
Most recent should be the best I would think.
Can you give any link/info for recompiling PHP
www.php.net ?
If you have never compiled PHP before I would suggest reading up on
compilation before-hand and even asking the php help list. Recompiling
PHP also means you need to recompile Apache (if that is the web server
you are using).
Jean-Christian Imbeault
Hi
did you configure php for PostgreSQL support
./configure --with-pgsql
Regards
Conni
On Tuesday 05 August 2003 03:31 am, Jean-Christian Imbeault wrote:
shreedhar wrote:
Is it necessary to uninstall previous version of PHP in my system.
No，but a new recompile will probably over-write the version you have now.
Which is the better compatible version for Postgre 7.3.2.
Most recent should be the best I would think.
Can you give any link/info for recompiling PHP
www.php.net ?
If you have never compiled PHP before I would suggest reading up on
compilation before-hand and even asking the php help list. Recompiling
PHP also means you need to recompile Apache (if that is the web server
you are using).
No, you don't need to recompile Apache to recompile PHP, just restart the
webserver.
My guess would be when you update the new postgresql library override the old
one, so PHP needs to be recompile to use the new library.
My suggestion, easiest thing to do would be to write a PHP script with just
<?
phpinfo();
?>
and run the script (or browse it through the web). You will see all your old
configure options there. Use that to configure your new PHP (make sure you
have the option --with-pgsql), do "make", 'make install', and you should be
good to go.
RDB
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-------------------------------------------------
/"\ ASCII Ribbon Campaign against HTML
\ / email and proprietary format
X attachments.
/ \
-------------------------------------------------
Have you been used by Microsoft today?
Choose your life. Choose freedom.
Choose LINUX.
-------------------------------------------------
Hi All,
After Updating Postgre Server from 7.2.4 to 7.3.2, I have recompiled same
version of PHP which is available earlier in RH7.3 (i.e. PHP 4.1.2).
Updated php.ini.
But still pg_connect problem is persisting.
Regards,
Sreedhar
----- Original Message -----
From: "Reuben D. Budiardja" <techlist@voyager.phys.utk.edu>
To: "Jean-Christian Imbeault" <jc@mega-bucks.co.jp>; "shreedhar"
<shreedhar@lucidindia.net>
Cc: "Postgre General" <pgsql-general@postgresql.org>
Sent: Tuesday, August 05, 2003 7:52 PM
Subject: Re: [GENERAL] Fatal error: Call to undefined function: pg_connect()
On Tuesday 05 August 2003 03:31 am, Jean-Christian Imbeault wrote:
shreedhar wrote:
Is it necessary to uninstall previous version of PHP in my system.
No，but a new recompile will probably over-write the version you have
now.
Which is the better compatible version for Postgre 7.3.2.
Most recent should be the best I would think.
Can you give any link/info for recompiling PHP
www.php.net ?
If you have never compiled PHP before I would suggest reading up on
compilation before-hand and even asking the php help list. Recompiling
PHP also means you need to recompile Apache (if that is the web server
you are using).No, you don't need to recompile Apache to recompile PHP, just restart the
webserver.My guess would be when you update the new postgresql library override the
old
one, so PHP needs to be recompile to use the new library.
My suggestion, easiest thing to do would be to write a PHP script with
just
<?
phpinfo();
?>
and run the script (or browse it through the web). You will see all your
old
configure options there. Use that to configure your new PHP (make sure you
have the option --with-pgsql), do "make", 'make install', and you should
be
Show quoted text
good to go.
RDB
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-------------------------------------------------
/"\ ASCII Ribbon Campaign against HTML
\ / email and proprietary format
X attachments.
/ \
-------------------------------------------------
Have you been used by Microsoft today?
Choose your life. Choose freedom.
Choose LINUX.
----------------------------------------------------------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)