Re: windows update screwed up PostgreSQL -- Problem solved

From: "Frances Collier" <fcollier(at)preparedresponse(dot)com>
To: "'John DeSoi'" <desoi(at)pgedit(dot)com>
Subject: Re: windows update screwed up PostgreSQL -- Problem solved
Date: 2006-06-16 20:03:51
Message-ID: C96E5A95-A37F-4C41-B261-B4E2154AB83A@preparedresponse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pgedit(dot)com]
Sent: Thursday, June 15, 2006 5:14 PM
To: Frances Collier
Cc: pgsql-novice(at)postgresql(dot)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

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-06-16 21:49:00 Re: Converting stored procedure from mySQL
Previous Message Bruce Momjian 2006-06-16 20:00:58 Re: libpq Describe Extension [WAS: Bytea and perl]