Thread: windows update screwed up PostgreSQL

Hello,

I had PostgreSQL 8.1 running on a Windows Server 2003 just this morning.
Then I ran Windows update. Somehow that managed to muck up my PostgreSQL.
Now, when I try to login to my DB I get an error stating: "could not connect
to server: Connection refused (0x0000274D/10061) Is the server running on
host "???" and accepting TCP/IP connections on port 5432"

I've checked my postgresql.conf and I have the following:
  listen_addresses = '*'
  port = 5432

I'm stumped. I tried to uninstall the updates, but that didn't work. Can
anyone give me an idea as to what happened and/or what I need to do?

Thank you,
Frances Collier
Prepared Response, Inc.

On Jun 15, 2006, at 5:39 PM, Frances Collier wrote:

> I've checked my postgresql.conf and I have the following:
>   listen_addresses = '*'
>   port = 5432
>
> I'm stumped. I tried to uninstall the updates, but that didn't
> work. Can
> anyone give me an idea as to what happened and/or what I need to do?


If I recall correctly, an XP update I ran not too long ago killed
remote access to PostgreSQL. A change had to be made to the built-in
firewall to allow access to port 5432. I don't have Windows 2003, but
maybe try searching the help documentation related to "firewall" and
related things.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL