Thread: unable to connect to PostgreSQL server

I'm getting an error message :

Warning: Unable to connect to PostgreSQL server: PQconnectDB() -- couldn't read
postmaster response: errno=104 Connection reset by peer in /var/www/html/test1.php
on line 24

my PHP script is :

if($myconn = pg_connect("dbname=mydb
   host=localhost
   port=443
   user=faudzy
   "))
{ echo "Connection to PostgreSQL server 'localhost' successful<br>\n"; }


how do I fix it ?


thanks.

------------------------------
http://www.um.edu.my

On Mié 23 Ene 2002 03:41, you wrote:
> I'm getting an error message :
>
> Warning: Unable to connect to PostgreSQL server: PQconnectDB() -- couldn't
> read postmaster response: errno=104 Connection reset by peer in
> /var/www/html/test1.php on line 24
>
> my PHP script is :
>
> if($myconn = pg_connect("dbname=mydb
>    host=localhost
>    port=443

Try eliminating this line (don't put the port).
Also, check if the postmaster is running in the server.

Saludos... :-)

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------