failed connection to postgres

From: SG Edwards <s0460205(at)sms(dot)ed(dot)ac(dot)uk>
To: pgsql-php(at)postgresql(dot)org
Subject: failed connection to postgres
Date: 2005-03-31 15:38:55
Message-ID: 1112283535.424c198f6f8ec@sms.ed.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

If I use the following code to connect to postgres using PHP:

<?php
echo "trying to connect to the database...";

$conn =pg_connect("host=localhost dbname=milker dbuser=s0460205
dbpass=password");

if (!$conn) {
echo "no connection";
}
?>

However, the connection is not made. If I try to run it from the command line in
UNIX I get the following error:

PHP warning: pg_connect(): Unable to connect to PostgreSQL server: invalid
connection option &quot;dbuser&quot; in /home/s0460205/public_html/first.php on
line 12

The username, database name and password are definately right and my database is
on the same server as the script (thus I assume localhost for host?) so should
this not work?

Many thanks for your help

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Heather Johnson 2005-03-31 15:42:59 Re: failed connection to postgres
Previous Message Christopher Kings-Lynne 2005-03-30 06:32:45 Help needed to rewrite PHP PostgreSQL docs