connection fails

From: paula(at)cyberlazarus(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: connection fails
Date: 2001-09-21 19:25:25
Message-ID: 20010921192525.551.qmail@k92.maski.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I\'m trying to connect using an extremely simple php script:

$conn = pg_Connect(\"host=localhost dbname=db name user=postgres password=postgres\");

if ($conn) { echo \"ok\"; }
else { echo \"failed\"; }

I get this error message:

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/www/sts.twcable.com/launch_plan/test/c.php on line 3
failed

I also tried to work from the command line and get similar error messages.
The weird thing is that phpPgAdmin is working fine and this script works:

$database = pg_Connect (\"dbname=dbname\");
pg_exec ($database, \"begin\");
$oid = pg_locreate ($database);
echo (\"$oid\\n\");
$handle = pg_loopen ($database, $oid, \"w\");
echo (\"$handle\\n\");
pg_lowrite ($handle, \"gaga\");
pg_loclose ($handle);
pg_exec ($database, \"commit\");

[script coming from php.net]

Any ideas??

thnx!
/paula

----------------------------------------------------------------
:: www.nervemail.net :: free access to POP3 accounts

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gurunandan R. Bhat 2001-09-21 20:19:01 Problem while logging primary key of updated field.
Previous Message Alex Pilosov 2001-09-21 19:14:57 Re: Postgres 7.1.3 on OpenBSD 2.9?