php connect postgresql via command line but cant via apache

[eMurat]

There is an interesting situation, if I run the php code from the command line it connects to the database, but when I try it from the browser it won't connect.

I have a very simple link code actually, I use it to try it out:

This is the code:

Code: Select all

$dbconn = pg_connect("host=localhost port=5432 dbname=DBNAME user=postgres password=XXXXX")   
/* if cant connect */
or die('Could not connect: ' . pg_last_error());

/* if connect : */
echo 'connection is success';


If I run this code from the command line it works fine:


But when I run it from the browser it doesn't work properly.



Has anyone encountered this error and knows the solution?