Re: [HACKERS] pg_connect error - Mailing list pgsql-general

From Brian Edginton
Subject Re: [HACKERS] pg_connect error
Date
Msg-id 8slma4$1d62$1@news.aros.net
Whole thread Raw
In response to Re: [HACKERS] pg_connect error  (Travis Bauer <trbauer@indiana.edu>)
Responses Re: [HACKERS] pg_connect error  (Travis Bauer <trbauer@indiana.edu>)
List pgsql-general
Travis Bauer <trbauer@indiana.edu> wrote:

> When you compiles php, did you ./configure with --with-pgsql?  If you did
> not compile php explicitly telling it to includ pgsql support, it probably
> didn't.

Yes I did, and postgresql is installed in the default location. Notice that
the pg_connect from the pgsql module (ext/pgsql) is being executed, it's
just not finding the PQconnectdb function from the libpq.so library.

> Travis

> Brian Edginton (edge@aros.net) wrote:

>>
>>
>> I'm trying to use the php/postgresql interface via my apache server.
>> When I try and load a page containing:
>>
>> <?php $db = pg_connect( "database=mydb owner=me" )
>>      or die ( "could not connect" ) ?>
>>
>> (both the database and owner are valid and tested via psql)
>>
>> apache complains:
>> /usr/libexec/ld.so: Undefined symbol "_PQconnectdb" called from httpd:/usr/lib/apache/modules/libphp4.so at
0x4030a394
>>
>> I have verified through ldconfig that libpq.so.2.0 is being loaded into hints,
>> what am I missing?
>>
>> Thanks,
>>  edge
>>


pgsql-general by date:

Previous
From: Brian Edginton
Date:
Subject: Re: [HACKERS] pg_connect error
Next
From: Brian Edginton
Date:
Subject: Re: [HACKERS] pg_connect error