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

Good Morning,

I suppose it was the problem, but to solve this, I have disabled the windows
firewall.  I am worried because I have a server with windows 2003 server
running and sql server 2005 and IIS and PHP and Postgres 8.1, I tried to
connect locally but the problem is the same, I installed the same version of
Postgres in other computer and it works good, I made a copy of the folder on
my server and I replaced the new Postgres installation in the other
computer, and it the new computer still working good, but I couldn=92t see =
the
data bases. I know the Postgres data files folder but it is invisible to new
installation.=20

How I can solve this problem with this port. I stopped the Postgres service
in my server, and I started it again, I have restarted the server, I=92ve
configured the Postgres configuration files manually, and disable the
firewall and the problem persists.

What happened with my server, time ago the Postgres 8.1 had worked perfect,
and 2 days ago it leaves.
I used the command =93net stat =96a=94 to see the ports and I can not find =
5432
port.





________________________________

James Humberto Becerra Ramirez=20
Data Manager
ICIDR - Data Management Core=20
jbecerra@cideim.org.co / jameshbr@gmail.com=20
CIDEIM - Centro Internacional De Entrenamiento e Investigaciones M=E9dicas=
=20
www.cideim.org.co=20
________________________________

           WARNING!

Este mensaje y/o sus anexos son para uso exclusivo de CIDEIM. Puede contener
informaci=F3n legalmente protegida por ser privilegiada o confidencial. Si
usted no es el destinatario intencional del mensaje, por favor inf=F3rmenos=
 de
inmediato y elimine el mensaje y su anexos de su computador y sistema de
comunicaciones. Igualmente, le comunicamos que cualquier retenci=F3n, revis=
i=F3n
no autorizada, distribuci=F3n, divulgaci=F3n, reenv=EDo, copia, impresi=F3n,
reproducci=F3n o uso indebido de este mensaje y/o anexos, esta estrictamente
prohibida y sancionada legalmente
=09

-----Original Message-----
From: Stefan Kaltenbrunner [mailto:stefan@kaltenbrunner.cc]=20
Sent: Mi=E9rcoles, 24 de Enero de 2007 03:59 p.m.
To: James Becerra
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #2929: Error opening 5432 port

James Becerra wrote:
> The following bug has been logged online:
>=20
> 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:=20
>=20
> Hi,
>=20
> Let me explaint my problem.
>=20
> I usually work with postgres, but i dont know how it happend, this error
> doesnt permit to run my php aplications.
>=20
> 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?=20

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




--=20
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.17.8/649 - Release Date: 23/01/2007