do i need to do something to get postgresSQL working with PHP?

steveryan

hi,

i normally use MySQL as my backend database, but for the project i'm working on at the moment i must use postgresSQL.

i have installed postgresSQL and it is working fine, but for some reason my postgresSQL commands aren't working.

for example, this command:
$result = pg_pconnect("host=localhost dbname=infolines1 user=user1 password=password1");

is returning this error:
Fatal error: Call to undefined function: pg_pconnect() in /usr/local/apache/htdocs/mcash/db_fns.php on line 5

any one have any ideas? do i need to recompile PHP with some postgres flag set?

thanks!

piersk

Have you changed the settings in the php.ini file? SOunds stupid I know, but you may have forgotten to allow for this?

steveryan

i don't have a php.ini file, but rather a php.ini-dist file.

here is what it says about postgres:

[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
pgsql.max_links = -1

is this OK? i'm fairly new to PHP so be gentle! thanks 😉

Frag

You did compile php with postgresql support?

--with-pgsql=<dir>

Frag

steveryan

i'm after recompiling PHP (upgraded to 4.2.3)

my phpinfo() is telling me i'm still using PHP Version 4.1.2 for some reason. it has also not picked up my new .configure which did include --with-pgsql

am i doing something wrong?

doing a sequence of commands like this should work, right?
(while in my php folder)
./configure --with-mysql --with-apache=/home/sryan/apache_1.3.23 --with-pgsql
make clean; make
make install

it runs through everything, displays no errors.

but i still can't get any postgres commands to work (but can use postgres from the command line of course)

arrrgh this is very frustrating...

Frag

Have you checked your ini files for both php and apache for discrepancies?

You must also move your php-dist ini file to where it's supposed to me and rename it php.ini

Sxooter

1: You need to restart apache for the change to take place: apache_ctl stop;apache_ctl start

2: Never use the --with-apache switch unless you have to. The preferred method is to use the --with-apxs=/usr/local/apache/bin/apxs method, which makes apache use php as a shared object rather than a statically linked one.

Let us know if you need any more help.