Can"t Get PHP Going on PostgreSQL

SSBhbSBuZXcgdG8gYm90aCBQSFAgYW5kIFBvc3RncmVTUUwuIFRyeWluZyB0
byBpbnN0YWxsIFBIUCBhbmQgUG9zdGdyZVNRTCA4LjAgb24gU2xhY2t3YXJl
IExpbnV4IDEwLjAuMCAuIA0KSSBhbSBnZXR0aW5nIHRoZSBmb2xsb3dpbmcg
ZXJyb3Igb3V0IG9mIEFwYWNoZToNCiAgICJGYXRhbCBFcnJvcjogQ2FsbCB0
byB1bmRlZmluZWQgZnVuY3Rpb246IHBnX2Nvbm5lY3QoKSAuLi4uIg0KDQpQ
b3N0Z3JlU1FMIGlzIHVwIGFuZCBydW5uaW5nLCBhbmQgYXBwZWFycyB0byBi
ZSBmaW5lLiANCg0KSGF2ZSBmb3VuZCBhIGxvdCBvZiB3ZWIgcmVmZXJlbmNl
cyB0byB0aGlzOyB0aGUgYmVzdCB3YXMgaHR0cDovL3VzMi5waHAubmV0L3Bn
c3FsIC4gQnV0IGFtIHVuYWJsZQ0KdG8gcHJvY2VlZCBiZWNhdXNlIEkgYW0g
bm90IHN1cmUgd2hhdCB0byBkby4gDQogDQpGYWN0cyBhYm91dCB3aGF0IEkg
aGF2ZSBpbnN0YWxsZWQ6IA0KLSBJbnN0YWxsZWQgUEhQIGZyb20gU2xhY2t3
YXJlIGJpbmFyeTsgSSBtYWRlIG5vIHNwZWNpYWwgZWZmb3J0cyB0byBjb21w
aWxlIGl0LiBBY2NvcmRpbmcgdG8gYSBQSFAgdXRpbGl0eQ0KICBmdW5jdGlv
biAocGhwaW5mbygpKSwgbG9va3MgbGlrZSBpdCBtaWdodCBiZSBjb25maWd1
cmVkIGZvciBNeVNRTCBhbHJlYWR5LiANCi0gdmVyc2lvbiBpbmZvOg0KICAg
IFBIUCA9ICA0LjMuNw0KICAgIExpbnV4IGtlcm5lbCA9IDIuNC4yNg0KICAg
QXBhY2hlID0gMS4zLjMxDQogDQpIb3cgZG8gSSBmaW5kIHRoZXNlIGZ1bmN0
aW9ucyBhbmQgaW5zdGFsbCBPUiBjb25maWd1cmUgdGhlIHBocC5pbmkgZmls
ZT8NCiANCkkgZG9uJ3QgdGhpbmsgdGhpcyBpcyBoYXJkIHRvIGZpeCwgYnV0
IGl0IGlzIGJlYXRpbmcgbWUgdXAgcmlnaHQgbm93LiBXaGF0IEkgbmVlZCB0
byBmaW5kIGEgYmxvdy1ieS1ibG93IG9mIA0Kd2hhdCB0byBkby4gQ2FuIHNv
bWVib2R5IGhlbHAgbWU/DQoKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
KGVuZCBvZiBicm9hZGNhc3QpLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
ClRJUCA0OiBEb24ndCAna2lsbCAtOScgdGhlIHBvc3RtYXN0ZXIK

Re: Can"t Get PHP Going on PostgreSQL

Your php install doesn't know about (or can't find) the postgresql
extension. Default installs don't usually include postgresql support I
think.

run this command

ldd /usr/local/apache/libexec/libphp4.so

where the second parameter is the location of your php module for apache.

This will list the shared object files that php needs. If you don't see a
line like this

libpq.so.3 => /usr/lib/libpq.so.3 (0x4001b000)

then php was not compiled to include postgresql.

Thom Dyson
Director of Information Services
Sybex, Inc.



pgsql-php-owner@postgresql.org wrote on 03/10/2005 01:08:47 PM:

> I am new to both PHP and PostgreSQL. Trying to install PHP and
> PostgreSQL 8.0 on Slackware Linux 10.0.0 .
> I am getting the following error out of Apache:
> "Fatal Error: Call to undefined function: pg_connect() ...."

> PostgreSQL is up and running, and appears to be fine.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Can"t Get PHP Going on PostgreSQL

PgSQL support isn't compiled into that. You can make a script like
to output what support is compiled in. Your best
bet will to be to download the php source and compile it in yourself,
unless there is a pgsql module laying around. I switched from slack a
few years back so I'm not sure what they're doing with the php package
these days. If you decide to compile it from source, just do
a ./configure --with-pgsql (and other options you want/need) and
--with-apxs and that should get you what you need.

Good luck :)

Gavin



On Thu, 2005-03-10 at 16:08 -0500, Van Ingen, Lane wrote:
> I am new to both PHP and PostgreSQL. Trying to install PHP and PostgreSQL 8.0 on Slackware Linux 10.0.0 .
> I am getting the following error out of Apache:
> "Fatal Error: Call to undefined function: pg_connect() ...."
>
> PostgreSQL is up and running, and appears to be fine.
>
> Have found a lot of web references to this; the best was http://us2.php.net/pgsql . But am unable
> to proceed because I am not sure what to do.
>
> Facts about what I have installed:
> - Installed PHP from Slackware binary; I made no special efforts to compile it. According to a PHP utility
> function (phpinfo()), looks like it might be configured for MySQL already.
> - version info:
> PHP = 4.3.7
> Linux kernel = 2.4.26
> Apache = 1.3.31
>
> How do I find these functions and install OR configure the php.ini file?
>
> I don't think this is hard to fix, but it is beating me up right now. What I need to find a blow-by-blow of
> what to do. Can somebody help me?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


---------------------------(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

Re: Can"t Get PHP Going on PostgreSQL

On Thu, 2005-03-10 at 16:08 -0500, Van Ingen, Lane wrote:
> I am new to both PHP and PostgreSQL. Trying to install PHP and PostgreSQL 8.0 on Slackware Linux 10.0.0 .
> I am getting the following error out of Apache:
> "Fatal Error: Call to undefined function: pg_connect() ...."
>
> PostgreSQL is up and running, and appears to be fine.
>
> Have found a lot of web references to this; the best was http://us2.php.net/pgsql . But am unable
> to proceed because I am not sure what to do.
>
> Facts about what I have installed:
> - Installed PHP from Slackware binary; I made no special efforts to compile it. According to a PHP utility
> function (phpinfo()), looks like it might be configured for MySQL already.
> - version info:
> PHP = 4.3.7
> Linux kernel = 2.4.26
> Apache = 1.3.31
>
> How do I find these functions and install OR configure the php.ini file?
>
> I don't think this is hard to fix, but it is beating me up right now. What I need to find a blow-by-blow of
> what to do. Can somebody help me?

You need to install with pgsql support.

in your configure:


../configure ... --with-pgsql

-Robby

--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | robby@planetargon.com
* 503.351.4730 | blog.planetargon.com
* PHP-PostgreSQL Hosting & Development
* open source solutions - web hosting
****************************************/


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: Can"t Get PHP Going on PostgreSQL

SSBkaWQgYSBmaW5kLCBhbmQgZm91bmQgSSBoYXZlIHNldmVyYWwgY29uZmln
dXJhdGlvbiBwcm9ncmFtcyBvbiB0aGUgc3lzdGVtLiBBc3N1bWUgdGhhdCBz
aW5jZSBJIGFtDQpjb25maWd1cmluZyBQSFAsIHRoYXQgc2hvdWxkIGJlIGlu
IGEgUEhQIGRpcmVjdG9yeS4gTW9zdCBsaWtlbHkgd2FzIC91c3Ivc2hhcmUv
bGlidG9vbC9saWJsdGRsL2NvbmZpZ3VyZSwNCmJ1dCBhbSBub3Qgc3VyZSBv
ZiB0aGF0Lg0KIA0KQWxzbywgd2hhdCAoZmlsZXMpIGRvZXMgaXQgcmVxdWly
ZSB0byBkbyBpdHMgJ2NvbmZpZ3VyZScsIGlmIGFueT8NCiANCi0tLS0tT3Jp
Z2luYWwgTWVzc2FnZS0tLS0tIA0KRnJvbTogUm9iYnkgUnVzc2VsbCBbbWFp
bHRvOnJvYmJ5QHBsYW5ldGFyZ29uLmNvbV0gDQpTZW50OiBUaHUgMy8xMC8y
MDA1IDk6MDAgUE0gDQpUbzogVmFuIEluZ2VuLCBMYW5lIA0KQ2M6IHBnc3Fs
LXBocEBwb3N0Z3Jlc3FsLm9yZyANClN1YmplY3Q6IFJlOiBbUEhQXSBDYW4n
dCBHZXQgUEhQIEdvaW5nIG9uIFBvc3RncmVTUUwNCg0KT24gVGh1LCAyMDA1
LTAzLTEwIGF0IDE2OjA4IC0wNTAwLCBWYW4gSW5nZW4sIExhbmUgd3JvdGU6
DQo+IEkgYW0gbmV3IHRvIGJvdGggUEhQIGFuZCBQb3N0Z3JlU1FMLiBUcnlp
bmcgdG8gaW5zdGFsbCBQSFAgYW5kIFBvc3RncmVTUUwgOC4wIG9uIFNsYWNr
d2FyZSBMaW51eCAxMC4wLjAgLg0KPiBJIGFtIGdldHRpbmcgdGhlIGZvbGxv
d2luZyBlcnJvciBvdXQgb2YgQXBhY2hlOg0KPiAgICAiRmF0YWwgRXJyb3I6
IENhbGwgdG8gdW5kZWZpbmVkIGZ1bmN0aW9uOiBwZ19jb25uZWN0KCkgLi4u
LiINCj4NCj4gUG9zdGdyZVNRTCBpcyB1cCBhbmQgcnVubmluZywgYW5kIGFw
cGVhcnMgdG8gYmUgZmluZS4NCj4NCj4gSGF2ZSBmb3VuZCBhIGxvdCBvZiB3
ZWIgcmVmZXJlbmNlcyB0byB0aGlzOyB0aGUgYmVzdCB3YXMgaHR0cDovL3Vz
Mi5waHAubmV0L3Bnc3FsIC4gQnV0IGFtIHVuYWJsZQ0KPiB0byBwcm9jZWVk
IGJlY2F1c2UgSSBhbSBub3Qgc3VyZSB3aGF0IHRvIGRvLg0KPiANCj4gRmFj
dHMgYWJvdXQgd2hhdCBJIGhhdmUgaW5zdGFsbGVkOg0KPiAtIEluc3RhbGxl
ZCBQSFAgZnJvbSBTbGFja3dhcmUgYmluYXJ5OyBJIG1hZGUgbm8gc3BlY2lh
bCBlZmZvcnRzIHRvIGNvbXBpbGUgaXQuIEFjY29yZGluZyB0byBhIFBIUCB1
dGlsaXR5DQo+ICAgZnVuY3Rpb24gKHBocGluZm8oKSksIGxvb2tzIGxpa2Ug
aXQgbWlnaHQgYmUgY29uZmlndXJlZCBmb3IgTXlTUUwgYWxyZWFkeS4NCj4g
LSB2ZXJzaW9uIGluZm86DQo+ICAgICBQSFAgPSAgNC4zLjcNCj4gICAgIExp
bnV4IGtlcm5lbCA9IDIuNC4yNg0KPiAgICBBcGFjaGUgPSAxLjMuMzENCj4g
DQo+IEhvdyBkbyBJIGZpbmQgdGhlc2UgZnVuY3Rpb25zIGFuZCBpbnN0YWxs
IE9SIGNvbmZpZ3VyZSB0aGUgcGhwLmluaSBmaWxlPw0KPiANCj4gSSBkb24n
dCB0aGluayB0aGlzIGlzIGhhcmQgdG8gZml4LCBidXQgaXQgaXMgYmVhdGlu
ZyBtZSB1cCByaWdodCBub3cuIFdoYXQgSSBuZWVkIHRvIGZpbmQgYSBibG93
LWJ5LWJsb3cgb2YNCj4gd2hhdCB0byBkby4gQ2FuIHNvbWVib2R5IGhlbHAg
bWU/DQoNCllvdSBuZWVkIHRvIGluc3RhbGwgd2l0aCBwZ3NxbCBzdXBwb3J0
Lg0KDQppbiB5b3VyIGNvbmZpZ3VyZToNCg0KDQouL2NvbmZpZ3VyZSAuLi4g
LS13aXRoLXBnc3FsDQoNCi1Sb2JieQ0KDQotLQ0KLyoqKioqKioqKioqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKg0KKiBSb2JieSBSdXNzZWxsIHwg
T3duZXIuRGV2ZWxvcGVyLkdlZWsNCiogUExBTkVUIEFSR09OICB8IHd3dy5w
bGFuZXRhcmdvbi5jb20NCiogUG9ydGxhbmQsIE9SICB8IHJvYmJ5QHBsYW5l
dGFyZ29uLmNvbQ0KKiA1MDMuMzUxLjQ3MzAgIHwgYmxvZy5wbGFuZXRhcmdv
bi5jb20NCiogUEhQLVBvc3RncmVTUUwgSG9zdGluZyAmIERldmVsb3BtZW50
DQoqIG9wZW4gc291cmNlIHNvbHV0aW9ucyAtIHdlYiBob3N0aW5nDQoqKioq
KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqLw0KDQoNCgot
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0oZW5kIG9mIGJyb2FkY2FzdCkt
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KVElQIDU6IEhhdmUgeW91IGNo
ZWNrZWQgb3VyIGV4dGVuc2l2ZSBGQVE/CgogICAgICAgICAgICAgICBodHRw
Oi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvZmFxCg==

Re: Can"t Get PHP Going on PostgreSQL

Van Ingen, Lane wrote:
> I did a find, and found I have several configuration programs on the system. Assume that since I am
> configuring PHP, that should be in a PHP directory. Most likely was /usr/share/libtool/libltdl/configure,
> but am not sure of that.
>
> Also, what (files) does it require to do its 'configure', if any?
>

How did you install PHP in the first place? If your using Linux and you
used your distributions package system, it's fairly likely that there
will be a php module for postggresql in your package system as well.
F.ex. on debian it's "apt-get install php4-pgsql" which will install the
module, and activate support for it.
What distribution/os are you using?

Tommy


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org