Re: Problems in connecting to postgreSQL using PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Here are my error messages from PHP:

[Mon Mar 12 16:01:26 2007] [error] [client] PHP Warning:   pg_connect() [<a href="" Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket &quot;/tmp/.s.PGSQL.5432&quot;? in /var/www/html/try.php on line 3

[Mon Mar 12 16:01:26 2007] [error] [client] PHP Warning:   pg_last_error() [<a href="" No PostgreSQL link opened yet in /var/www/html/try.php on line 4

PHP Code:


// Connecting, selecting database

$dbconn = pg_connect("dbname=test user=postgres")

   or die('Could not connect: ' . pg_last_error());


// Performing SQL query

$query = 'SELECT * FROM haha';

$result = pg_query($query) or die('Query failed: ' . pg_last_error());


// Printing results in HTML

echo "<table>\n";

while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {

   echo "\t<tr>\n";

   foreach ($line as $col_value) {

       echo "\t\t<td>$col_value</td>\n";


   echo "\t</tr>\n";


echo "</table>\n";


// Free resultset



// Closing connection






# "local" is for Unix domain socket connections only

local   all         all                                trust


# IPv4 local connections:

host    all         all          trust

# IPv6 local connections:

host    all         all          ::1/128               trust






# - Connection Settings -


listen_addresses = 'localhost'             # what IP address(es) to listen on;

                                        # comma-separated list of addresses;

                                        # defaults to 'localhost', '*' = all

port = 5432

max_connections = 100

# note: increasing max_connections costs ~400 bytes of shared memory per

# connection slot, plus lock space (see max_locks_per_transaction).  You

# might also need to raise shared_buffers to support more connections.

superuser_reserved_connections = 2

unix_socket_directory = ''

unix_socket_group = ''

unix_socket_permissions = 0777              # octal

bonjour_name = ''                     # defaults to the computer name
Thanks a lot,

On 3/12/07, Matthew Terenzio <matt@xxxxxxxxxxxxx> wrote:
Could you provide any PHP errors or the pg_hba.conf ?

On Mar 12, 2007, at 12:25 AM, Kitty Yuen wrote:

> Hi,
> I am trying to connect my postgreSQL with PHP in localhost. I have
> start up the server with -i flag (i.e. postmaster -D
> /usr/local/pgsql/data -i &) and edit the pg_hba.conf. However, I still
> cannot connect with the database. But, when I tried to remote access
> the database through SSH and I can connect with it.
> Would you please offer any suggestions or solutions?
> Manythanks,
> Kitty3A

[Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

Add to Google Powered by Linux