pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: connecting To PostgreSQL - Getting Error
2+ messages / 2 participants
[nested] [flat]

* Re: connecting To PostgreSQL - Getting Error
@ 2002-08-06 14:17  Dan Wilson <killroyboy@users.sourceforge.net>
  parent: Riyaz@umapinc.com
  0 siblings, 0 replies; 2+ messages in thread

From: Dan Wilson @ 2002-08-06 14:17 UTC (permalink / raw)
  To: Riyaz@umapinc.com; +Cc: pgsql-php

That port is not standard.  Are you sure that is the correct port to connect 
with?  Also, make sure you are using the tcpip_socket.  Check your 
postgresql.conf file and uncomment and turn on the tcpip_socket option.

Your other option is to just connect using the local socket (which is more 
secure anyway).  You can do this by just leaving of the host option in your 
connection string.

-Dan

Quoting Riyaz@umapinc.com:

> Hello All,
>     I am running Postgresql on a linux Qube and trying to connect to it 
> using PHP. But it is giving me the following error:
> 
> Warning: Unable to connect to PostgreSQL server: connectDB() -- connect()
> failed: 
> Connection refused Is the postmaster running (with -i) at 'localhost' and 
> accepting connections on TCP/IP port '5583'? in
> /home/groups/smarttools/web/testpg2.php on line 21
> 
> I don't think I am using Unix sockets as I can connect to the database on 
> psql monitor without -i option and without specifying the port number. 
> 
> Any tips on solving this?
> 
> Also in what files are connectDB - - connect() functions stored?
> 
> Thanks,
> Riyaz.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* connecting To PostgreSQL - Getting Error
@ 2002-08-06 15:18  Riyaz@umapinc.com
  0 siblings, 1 reply; 2+ messages in thread

From: Riyaz@umapinc.com @ 2002-08-06 15:18 UTC (permalink / raw)
  To: pgsql-php

Hello All,
    I am running Postgresql on a linux Qube and trying to connect to it 
using PHP. But it is giving me the following error:

Warning: Unable to connect to PostgreSQL server: connectDB() -- connect() failed: 
Connection refused Is the postmaster running (with -i) at 'localhost' and 
accepting connections on TCP/IP port '5583'? in /home/groups/smarttools/web/testpg2.php on line 21

I don't think I am using Unix sockets as I can connect to the database on 
psql monitor without -i option and without specifying the port number. 

Any tips on solving this?

Also in what files are connectDB - - connect() functions stored?

Thanks,
Riyaz.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-08-06 15:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-06 15:18 connecting To PostgreSQL - Getting Error Riyaz@umapinc.com
2002-08-06 14:17 ` Dan Wilson <killroyboy@users.sourceforge.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox