Re: BUG #2929: Error opening 5432 port - Mailing list pgsql-bugs

From Stefan Kaltenbrunner
Subject Re: BUG #2929: Error opening 5432 port
Date
Msg-id 45B7C896.6000500@kaltenbrunner.cc
Whole thread Raw
In response to BUG #2929: Error opening 5432 port  ("James Becerra" <jbecerra@cideim.org.co>)
Responses Re: BUG #2929: Error opening 5432 port  ("James Becerra" <jbecerra@cideim.org.co>)
List pgsql-bugs
James Becerra wrote:
> The following bug has been logged online:
>
> Bug reference:      2929
> Logged by:          James Becerra
> Email address:      jbecerra@cideim.org.co
> PostgreSQL version: 8.1
> Operating system:   Windows 2003 Server
> Description:        Error opening 5432 port
> Details:
>
> Hi,
>
> Let me explaint my problem.
>
> I usually work with postgres, but i dont know how it happend, this error
> doesnt permit to run my php aplications.
>
> could not connect to server: Connection refused (0x0000274D/10061) Is the
> server running on host "127.0.0.1" and accepting TCP/IP connections on port
> 5432?

well this simple means that you are trying to connect to localhost on
port 5432 and there is either nothing listening there or you have a
firewall blocking the request.
Have you checked that the postgresql service(from that error message I
assume you are running windows) is actually running and configured to
listen on that interface (it should be by default but somebody might
have changed that.
Another possibility would be some kind of firewall that is blocking the
request - if you have something like that you could try to disable it
temporary.


Stefan

pgsql-bugs by date:

Previous
From: "Feng Chen"
Date:
Subject: Postgres Stored Procedure Call Function Return Type OID Caching Problem
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #2927: Trigger execution hides foreign key error