cannot connect from php 1

[warby1212]

Hi,

I can't connect to Postgresql. The installation is "straight of the box" on Red Hat 8.2. PHP is runing ok.
I get this message in browser:

Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port 5432? in /var/

http://www/html/ste_post_php.php

on line 15
Could not open connection to database server

with this in the php file:
$host = "localhost";
$user = "postgres";
$pass = "postgres";
$db = "stedb";

$connection = pg_connect ("host=$host dbname=$db user=$user"

When I enter: postmaster -i -D /var/lib/psql/data
I get the message: ...postmaster.pid already exists

Can anyone suggest hwere I can look to get through?

Cheers stephen

 

[Leland123]

Hi stephen,

Try deleting the postmaster.pid file. Then postgres should start.

Regards,

LelandJ

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox

 

[ceco]

if it is localhost and it uses UNIX sockets (this is default for postgres)

try without host i.e.

$connection = pg_connect ("dbname=$db user=$user password=$pass"

if pg_hba.conf is configured with
local all all trust

then password is not needed

you can enable tcp usage in postgresql.conf, then you can connect with host=localhost

 

[warby1212]

Thanks for your replies all. I dropped "host" out of pg_connect and it is now returning true

but while I have your attention, my pg_query is producing the error:

"Call to undefined function: pg_query()"

A quick google around produced suggestions that Postgresql was not built into PHP. But if both came precompiled in the Red Hat release, wouldn't they be compatible and secondly does a successful pg_connect() prove compatability?

Thanks again
Stephen

 

[ceco]

if the php is old version the function is pg_exec()

 

[warby1212]

You're a champ, much appreciated.