pg_connect..

vickr1z · 10-18-2004, 05:50 AM

good day to all i have this simpe postgres php code that doesnt work.

db_load.php

PHP Code:



<?php 
$db_conn = pg_connect ("host=localhost dbname=testdb"); 
echo "<h1>Connection Information</h1>"; 
echo "Database name: " . pg_dbname($db_conn) . "<br>\n"; 
echo "Host name: " . pg_host($db_conn) . "<br>\n"; 
echo "Options: " . ph_options($db_conn) . "<br>\n"; 
echo "Port: " . pg_post($db_conn) . "<br>\n"; 
echo "TTY name: " . PG_TTY($db_conn) . "<br>\n"; 
pc_close ($db_conn); 
?>

my error is this:

Code:

Fatal error:  Call to undefined function: pg_connect() in /home/vvbuenaventura/data/projects/web/polmap_akbayan/pgstart.php on line 3

what behind this error means?
is it related to tcp/ip connection to postgresql?
i set tcp/ip = true on my postgresql.conf

hope you could help me here.. thanks in advance..

kriz

Tinkster · 10-18-2004, 03:59 PM

I have never used Postgres in conjunction with PHP
so far, but my educated guess would be that PHP wasn't
compiled with postgres-support/doesn't know anything
about Postgres in your installation since it says:
"undefined function"

That makes it (to me) appear as a problem of the
programming language/it's interface.

Cheers,
Tink

alejandroye · 12-19-2004, 11:36 PM

I having the same problem but I do not know what to do, I need some help about this
Looking about this problem I found this note in some website but I still do not know what to do HELP

==========================
"After upgrading to PHP 4.2.3 from PHP 4.1.2 (Red Hat Linux Advanced Server with Stronghold 4.0) in order to manually compile in MHASH support, I discovered that Postgres support has disappeared, despite being specified on the command line, and compiling with no errors.

FATAL: Undefined function: pg_connect()

Confirmed by looking at the output of phpinfo() and comparing it to the output pre-upgrade - no mention of PostgreSQL in the new one.

Detective work led me to find that the old pgsql.so in /usr/lib/php4 was untouched, and the new one had ended up in /usr/lib/20020429 instead.

The fix was to edit config_vars.mk after configuration to change the value of EXTENSION_DIR, and then compile.

Not quite sure where 20020429 came from, looks like a left-over value from development testing...

Anyway, in case any one else has a similar problem, thought I'd document it here, as a problem with pg_connect is where this will first surface as a symptom.
"
===========