Can't connect to 7.4 DB - Mailing list pgsql-php

From Michael Hanna
Subject Can't connect to 7.4 DB
Date
Msg-id 80431890-5D60-11D8-B81E-000A95B34330@sympatico.ca
Whole thread Raw
In response to PHP/PostGreSQL Articles  (David Costa <geeks@dotgeek.org>)
Responses Re: Can't connect to 7.4 DB  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Can't connect to 7.4 DB  (Joshua Drake <jd@commandprompt.com>)
List pgsql-php
Hi this php code:



    // add to DB

    // database access parameters
    $host = "localhost";
    $user = "postgres";
    $pass = "postgres";
    $db = "cosc3p94";

    // open a connection to the database server
    $connection = pg_connect("host=$host dbname=$db user=$user
password=$pass");

    if (!$connection)
    {
            die("Could not open connection to database server");
    }


    ...

results in:

Could not open connection to database server

and I'm not sure why. The web browser, web server, and database are on
the same machine..

I checked the pg_hba.conf and it says this:

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK
METHOD

local   all         all
trust
# IPv4-style local connections:
host    all         all         127.0.0.1         255.255.255.255
trust
# IPv6-style local connections:
host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ff$


which is untouched from the default settings...

Michael


pgsql-php by date:

Previous
From: David Costa
Date:
Subject: PHP/PostGreSQL Articles
Next
From: "scott.marlowe"
Date:
Subject: Re: Can't connect to 7.4 DB