Thread: Call to undefined function: pg_connect()
Hi All, I Updated my Postgresql Server from 7.2.4 which came along with RH7.3 to 7.3.2. After updating I could not able to connect database through PHP. So I recompiled PHP4.1.2 (same version which have earlier in my system), even then I am not able to connect through PHP. Is there any other package has to be installed for this connection. Please some body help me out regarding. I am breaking my head since two days. Thanks for any idea. Regards, Sreedhar Bhaskararaju
shreedhar wrote: > Hi All, > > I Updated my Postgresql Server from 7.2.4 which came along with RH7.3 to > 7.3.2. After updating I could not able to connect database through PHP. So I > recompiled PHP4.1.2 (same version which have earlier in my system), even > then I am not able to connect through PHP. Is there any other package has to > be installed for this connection. If I remember correctly, this is because libpq.so changed from libpq.so.2 to libpq.so.3. Is there an old copy of libpq.so.2 hanging around that is getting linked with instead of libpq.so.3? Did you re-run configure and do a `make clean` on PHP before rebuilding it? If you are really desperate, try creating a libpq.so.2 symlink from libpq.so.3. HTH, Joe
/usr/lib/libpq.so.2 /usr/lib/libpq.so.2.0 /usr/lib/libpq.so.2.2 /usr/lib/libpq.so I have the above versions of libpq.so in my system. Which I have to use. Suppose it might have to chage any config files where I should change. Thanks alot, With best regards, Sreedhar ----- Original Message ----- From: "Joe Conway" <mail@joeconway.com> To: "shreedhar" <shreedhar@lucidindia.net> Cc: "Postgre Admin" <pgsql-admin@postgresql.org>; "Postgre General" <pgsql-general@postgresql.org> Sent: Thursday, August 07, 2003 10:24 AM Subject: Re: [GENERAL] [ADMIN] Call to undefined function: pg_connect() > shreedhar wrote: > > Hi All, > > > > I Updated my Postgresql Server from 7.2.4 which came along with RH7.3 to > > 7.3.2. After updating I could not able to connect database through PHP. So I > > recompiled PHP4.1.2 (same version which have earlier in my system), even > > then I am not able to connect through PHP. Is there any other package has to > > be installed for this connection. > > If I remember correctly, this is because libpq.so changed from > libpq.so.2 to libpq.so.3. Is there an old copy of libpq.so.2 hanging > around that is getting linked with instead of libpq.so.3? Did you re-run > configure and do a `make clean` on PHP before rebuilding it? If you are > really desperate, try creating a libpq.so.2 symlink from libpq.so.3. > > HTH, > > Joe > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >
On Thu, 7 Aug 2003, shreedhar wrote: > Hi All, > > I Updated my Postgresql Server from 7.2.4 which came along with RH7.3 to > 7.3.2. After updating I could not able to connect database through PHP. So I > recompiled PHP4.1.2 (same version which have earlier in my system), even > then I am not able to connect through PHP. Is there any other package has to > be installed for this connection. I was playing the other day, and got pgsql 7.3.4, php 4.3.2 and apache 1.3.28 up and running fine on redhat 7.2 with all updates. Straighforward build. Had some issues trying to make older flavors of php work with apache after 1.3.27, but updating PHP helped on that. I'd recommend trying the latest version of PHP if you can upgrade to it, and see if that helps.