Re: windows update screwed up PostgreSQL -- Problem solved - Mailing list pgsql-novice

From Frances Collier
Subject Re: windows update screwed up PostgreSQL -- Problem solved
Date
Msg-id C96E5A95-A37F-4C41-B261-B4E2154AB83A@preparedresponse.com
Whole thread Raw
List pgsql-novice
In case anyone wants to know what was wrong... Somehow the postgresql
login
information got corrupted. After I reset that information, I started the
service through windows (versus postgresql) and it started up just fine.

Thank you for helping me out!

Frances Collier
Prepared Response, Inc.

-----Original Message-----
From: John DeSoi [mailto:desoi@pgedit.com]
Sent: Thursday, June 15, 2006 5:14 PM
To: Frances Collier
Cc: pgsql-novice@postgresql.org List
Subject: Re: [NOVICE] windows update screwed up PostgreSQL


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




pgsql-novice by date:

Previous
From: Verena Ruff
Date:
Subject: Re: Converting stored procedure from mySQL
Next
From: Tom Lane
Date:
Subject: Re: Converting stored procedure from mySQL